Fabs total issue

[bharani8]

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!

[bharani8]

Yes.. I have only 1 Dimension and 3 Expression..

[Frank_Hartmann]

=sum(aggr(fabs(sum(B)-Sum(A)),A,B))

[Anil_Babu_Samineni]

Can you share updated work file

[bharani8]

Sorry... in Agg function.. i didnt use Dimension.. i used my Expression .. Now working fine

[Anil_Babu_Samineni]

Good

[bharani8]

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 ?

[Anil_Babu_Samineni]

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)))

[bharani8]

Not working

[Anil_Babu_Samineni]

please share updated workfile ?

[bharani8]

Only({<Month>} Sum(Aggr(Fabs(sum({<Month>}B)-Sum({<Month>}A)), A, B)))

Above one is showin as wrong expression