Skip to Content
0
Former Member
Nov 09, 2011 at 09:45 AM

Formula in Query desinger in BEX

18 Views

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