Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I wanted to know if it is possible to have 2 expressions, where the 2nd expression is a MAX from the 1st expression.
Could that be possible?
Thank you!!!
Can you share your sample data or sample apps?
You can do it like below
Expression2 = Max(TOTAL Expression1)
Yes may be it will write like
If( Expressssion2 = Max(Expression1, True ExecuteStatement1, False ExecuteStatement2 )
And
IF(Sum(Expression2) = Max(Expression1), Statement1,statement2)
I guess you can try using AGGR() like:
Sum(Amt) = Max(Aggr(Sum(Amt) , Dimension1, ....))