Hi,
I want to create below formula in BEx which will be like :
Aging Bucket= IIF([Past Due Days]<=0,"Current",IIF([Past Due Days]<31,"1-30",IIF([Past Due Days]<61,"31 - 60",IIF([Past Due Days]<91,"61-90",IIF([Past Due Days]<181,"91 -180",IIF([Past Due Days]<361,"181 - 360",IIF([Past Due Days]>360,"360+")))))))
And Past due dates is one of my Keyfigure in the report. How can I acheive this using text variable? or is there any other way
Thanks,
Priya Bhat
Hello,
Please go through the following links:
Thanks.
With regards,
Anand Kumar
Hi
Try with BEx If conditions shown below
((Past due days<=0)Current) AND (Past due days<31)1-30) AND (Past due days<61)31-60) AND (Past due days<91)61-90) AND (Past due days<181)91-180) AND (Past due days<360)181-360) AND (Past due days>360)*360+)))
Regards
Jagadeesh
Add a comment