Wrong showing years in head columns...

[Former Member]

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.

Thank you.

[Former Member · Accepted solution]

Hi,

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...

Olivier.

[Former Member]

another idea..

first column - name it as - &ZFYEAR& (A)

second column - name it as - &ZFYEAR& (B)

third column - name it as - (A) / (B)

might not suit you.. still this is what we did instead of complicating

[Former Member]

Hello ,

Try having two text variables that is ZFYEAR for previous year and create another text variable ZCURRYEAR for current year and try giving both in the third column.

hope it helps

assign points if useful