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,