Skip to Content
Former Member
Aug 16, 2007 at 07:06 PM

How to Derive value in a text variable from numeric variable.


Hello experts!!

I have a requirement where i need to show some derived text in the column headers of my BEx query.

Say i have a text variable for the column header FYT which need to have the fiscal year text. I have another variable on 0FISCYEAR -- FY which has values of the fiscal year.

I have used FYT = &FY&, so, if FY = 2007, then the column header will show '2007'.

But my requirement is, If FY = 2007, then FYT should have FY-1, if FY = 2008, FYT should have FY-2 and so on.

I am not sure if we can use a normal and a text variable in a formula together. Please suggest what to do.

Thanks and Best Regards,

Vikas Bittera.