3 Replies Latest reply: Nov 21, 2011 4:23 AM by Robert Svebeck RSS

    Expression to find which expression is highest and lowest / dimension.

    Robert Svebeck


      Hi,


      I have a table with one single dimension and 4 advanced expressions.


      This is the result in a table:


      Item Expr1 Expr2 Expr3 Expr4
      A    10     20    10    5
      B    15     10    50   50
      C     1      6     2   -5


      Now - I want a 5th and a 6th expression that gives me which the value of the 4 "main" expression that returns the highest and lowest values.


      Expected result:


      Item Expr1 Expr2 Expr3 Expr4 Highest Lowest
      A       10       20       10       5    20      5
      B       15       10       50     50    50     10
      C         1        6          2     -5    6      -5


      The expressions 1-4 are complicated and based on set analysis, so I would prefere to be able to refer the max and min expressions to the expression aliases like this:


      Highest = getmymaxvalue([Expr1],[Expr2],[Expr3],[Expr4])


      I need to be able to present this in a table chart (not a pivot) so I can not use the hrank function, I guess...?
      ...And I would prefere not to use nested if's...


      Is it possible?


      Best Regards,


      Robert Svebeck