Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Working on a piece of expression using AGGR() function.
Expectated Result: Year is dimension and calculate sum of sales using aggr function. But the condition for each row i.e. Year is different
For Ex:1 Aggregate by LOB and verify that if sum >0 then show sum else 0 and then find sum
Year = 2008 condition1 = a
Year = 2009 Condition1 = B
When we try to put that in an expression is only shows for One condition and 0 for all other rows/years.
Any input/ help will or anyone ever faced this situation please help.
Thanks,
JD
Would you be able to elaborate with few rows of mocked up data as an example to show what you have?
Hi Sunny,
Sorry for the late reply.
Was able to resolved the issue using IF inside aggr function. earlier we were using Variable.