Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts - in the attached qv file.. I have created an expression which says Column B value Column A values... By the use of "Fabs" function i got all the expression values in positive.. But now i need the Total of all the values which came from my fab function..
I.e., in the attached example .. Total of my Expression should be 200 where as it shows only 40.. Please Help!
Yes.. I have only 1 Dimension and 3 Expression..
=sum(aggr(fabs(sum(B)-Sum(A)),A,B))
Can you share updated work file
Sorry... in Agg function.. i didnt use Dimension.. i used my Expression .. Now working fine
Good
Hi Anil... When i click on particular month.. i see right number.. but if more than a month is selected.. number seem to be wrong..
any idea ?
May be you can try this?
Only({<Month>} Sum(Aggr(Fabs(sum({<Month>}B)-Sum({<Month>}A)), A, B)))
OR
If(GetFieldSelections(Month) >=1,Sum(Aggr(Fabs(sum(B)-Sum(A)), A, B)), Fabs(Sum(B)-Sum(A)))
Not working
please share updated workfile ?
Only({<Month>} Sum(Aggr(Fabs(sum({<Month>}B)-Sum({<Month>}A)), A, B)))
Above one is showin as wrong expression