FABS in set analysis

[krish2459]

Hi,

Please me with the logic .

Requirement: Pareto graph

Where to use FABS in below expression.

expression1:

num(Sum({<Year=, Quarter=, Month=, Week=, [Pstng Date]={">=$(=Date(Max( [Pstng Date])-13))<=$(=Date(Max( [Pstng Date])))"}>} [Posting Amount] ),'##.##0')

expression2:

RangeSum(Above(Sum({<Year=, Quarter=, Month=, Week=, [Pstng Date]={">=$(=Date(Max( [Pstng Date])-13))<=$(=Date(Max( [Pstng Date])))"}>} [Posting Amount] ), 0, RowNo()))
/
Sum({<Year=, Quarter=, Month=, Week=, [Pstng Date]={">=$(=Date(Max( [Pstng Date])-13))<=$(=Date(Max( [Pstng Date])))"}>} total [Posting Amount] )

If possible please add an logic for soring also.

Thanks,

Kishore

[krish2459]

Any inputs please.

Thanks..

[sunny_talwar]

usage of fabs will depend on what you want to see... fabs and then sum or sum and then fabs. For example, if this is my data

-4

2

Do you want to see 2 fabs(Sum(Value)) or 6 Sum(fabs(Value))

[krish2459]

I want to make -10,-20,-30 as 10,20,30

[sunny_talwar]

But is that at the row level or summed up level?

[krish2459]

In data it self they were posting as Negative.

Thanks...

[krish2459]

Yes it is row level.

[sunny_talwar · Accepted solution]

Then should work

Num(Sum({<Year, Quarter, Month, Week, [Pstng Date] = {">=$(=Date(Max([Pstng Date])-13))<=$(=Date(Max([Pstng Date])))"}>} fabs([Posting Amount])), '##.##0')