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!

[Anil_Babu_Samineni]

May be this?

Sum(Aggr(Fabs(sum(B)-Sum(A)), A, B))

[Frank_Hartmann]

expression  tab, Total Mode --> Sum of Rows

[Anil_Babu_Samineni]

This option is not available in pivot table

[Frank_Hartmann]

i used his sample. where is he mentioning using pivot?

[Anil_Babu_Samineni]

What if Pivot?

[Frank_Hartmann]

thats not the question.

in his example he is using straight table

[bharani8]

Hi Anil.. I used your Formulae... But i see some wrong calculation happening here.. Chk the highlighted one..

[bharani8]

TY!..I need the number to be appearing in Text box as well..

[Anil_Babu_Samineni]

What expression you used in real data? I assume, you have only one Dimension so with in the aggregation you can use Only one dimension