Hi all,
I'm trying to add a value to a given presentation variable and have it shown in the column heading but it looks like BI is concatenating instead of adding. All other mathematical functions seems to function as expected.
Example, I am using a PVYearnr giving a current year, e.g. 2020
If I diminish '1' like @{PVYearnr-1} my result reads 2019
If I divide by '2' like @{PVYearnr/2} my result reads 1010
BUT if I add '1' like @{PVYearnr+1} or @{PVYearnr}+1 my result reads 20201 or 2020+1
Has somebody faced this problem earlier or do you know how to solve this issue?
Thanking in advance,
Arie