Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formula for the below query - Visokio Forums
Formula for the below query
  •     rajeshbalu29 January 11, 2012 4:47AM
    Please find the attached test data and we need a function for the column "Expected Return Value on weightage for a ID"
    The criteria is as below:
    IF the ID is unique then return the weightage column
    Else
    Find the max value from the weightage column for the ID and display it once to the cell as it should not be duplicated again.
    Please let me know if you have any clarification on my query.
    Attachments
    		 Test_Data.iok 5K
  • 2 Comments
  •     chris January 11, 2012 7:35AM
    Try using the following formula:

    IF (SUBSET_FIRST([Imp_ID], SUBSET([Id], [Id],"=")) = [Imp_ID],
    SUBSET_MAX([Weightage],SUBSET([Id], [Id],"=")),
    null)

    The logic behind this is: If the row is the first row with that particular ID, get the maximum weightage value.
  •     rajeshbalu29 January 11, 2012 9:14PM
    It works perfectly. Thanks a lot...
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged