Bucket / Ageing Issue

[prma7799]

Hi All,

I am not able to achieve ageing for Vendor Analysis. I want to create bucketing on Posting date basis.

Please find the attached QVW  with Expected Output.

In calendar object my date format will change in number when I am selecting any date i want it in DD/MM/YYYY

Thanks

[tresesco]

Though I am not really sure if your expected output is correct or not w.r.t the sample data, try correcting the number format for calendar display and correcting variable vMinDate to VMinDate to make it work. PFA.

[prma7799]

After correction same values are there I want output as attached excel ...

[prma7799]

If you look below in excel you will get bucketing Total that are not matching with your attached qvw

[PrashantSangle]

Hi,

try below expression

for 0 to 60 days bucket

=sum({<Posting_Num={">=$(=(vMaxDate-60))<=$(vMaxDate)"}>}Amount)

for 60 to 120 days bucket

=sum({<Posting_Num={">=$(=(vMaxDate-120))<$(=(vMaxDate-60))"}>}Amount)

for >120 days bucket

=sum({<Posting_Num={"<$(=(vMaxDate-120))"}>}Amount)

Regards,

Prashant Sangle

[Anil_Babu_Samineni]

Can you provide Excel Formulas as well