Wrong showing years in head columns...
A price column select a key figure price with for 0P_FYEAR-1. The head of column (description) is Price &ZFYEAR& and the result in query is Price 06, wich is correct.
A secon price column select a key figure price for 0P_FYEAR. The head of column (description) is Price &ZFYEAR& and the result in query is Price 07, wich is correct.
Question: How do I make a third column that calculates Price 07 / Price 06 and shows in head column the right years?? If I use the variable it shows Price &ZFYEAR&/&ZFYEAR& it shows this way, without showing the year.
Any idea would be appreciated.
since your column has two years, the system cannot determine the one single value for &ZFYEAR&.
Create two text varexits: one will read the value entered 0P_FYEAR and show it as text.
The other will also read 0P_FYEAR, subtract 1 and display its text.
hope this helps...