How to compute aging report only display >180 days amount ?

[paulyeo11]

Hi All

I have Table 1 using below expression from sunny working fine :-

=If(aging >= 1 and aging <= 30, Dual('1-30', 1),

If(aging >= 31 and aging <= 60, Dual('31-60', 2),

If(aging >= 61 and aging <= 90, Dual('61-90', 3),

If(aging >= 91 and aging <= 120, Dual('91-120', 4),

If(aging >= 121 and aging <= 150, Dual('121-150', 5),

If(aging >= 151 and aging <= 180, Dual('151-180', 6), Dual('>181', 7)))))))

Now i only want to filter company debt only > 180 Days , i try to modify the above expression to below :-

= If(aging >= 151 and aging <= 180, Dual('151-180', 6), Dual('Only >181', 7))

But it display the total amount at Table 2 ,I need table 2 display 22,559

Can some one advise me.

Paul

[paulyeo11]

my qvw

[trdandamudi · Accepted solution]

Please see the attached and hope this helps...

[paulyeo11]

Hi Thir

Thank you very much.

Paul

[sunny_talwar]

Another option

Dimension

='Only >181'

Expression

Sum({<aging = {'>=180'}>}da3_total * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

[paulyeo11]

Hi Sunny

Many Thank you for giving this option. As Dimension option is good when i have more expression.

Now my straight dimension only insert company_ap , and i am able to convert the table to chart. as this is finally what i want.

Paul