How to Offset a variable in column header text of a Report

[Former Member]

I'm using global variable &0FP to display the Period.Year in the Column Header text of a CO-PA report. I have subsequent columns with data from previous months. Can anyone tell me how do I offset this variable &0FP to display the previous months on the column header text of my report. Is there an alternative work around?

Thanks

SB

[former_member188826 · Accepted solution]

You can try in the subsequent column, choosing the same variable 0FP but in the bottom left, there shall be a field named operator. Choose minus symbol in that and offet by 1.

[Former Member · Accepted solution]

Thanks Sridhar... but i think what you are saying is when we chose a value field based on the characteristic "Period" you have a option of choosing the current fiscal period (&0FP) and then offsetting it by 1 using operator and offset.

However my question is about the Column header text for that column. In that text field you can enter &0FP and when you execute the report you get 009.2007 for eg as the heading for that column. I want the header text to display 009.2007 | 008.2007 | 007.2007 etc...

Thanks

SB

[former_member188826 · Accepted solution]

My bad! I tried with no luck! I'm sorry I didn't read it well first time!