Dear colleague,
I have a query which uses Text variable as column header. For example (we are in period 9,2005);
- one column is displaying the current period/ previous fiscal year (&PYCMACT&), so the column header is: 009/2004
- another column is displaying the current period/ current fiscal year (&CYCMACT&), so the column header is: 009/2005
There is another column which should display both text variable: 009/2004 to 009/2005 (&PYCMACT& to &CYCMACT&), but the system does not recognize those variables.
The system says:
Text variable PYCMACT, which is found in the item " PY vs CY Actual", needs to be replaced by the value of the characteristic 0FISCPER. This value is not clearly specified in the item " PY vs CY Actual". Therefore, no replacement takes place.
I tried every possible options I could think of, but whatever I try (selecting 0FISCPER as filter value, free characteristic, etc.), I still get the same error message.
Any hint would be greatly appreciated. Thank you very much!
Sylvain