Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have this weird behavior in my pivot chart I don't succeed to explain and hope you will find an explanation !
I have:
in the chart, I have the right figures for
- vSalesInno
- Sales
but not Sales_wo_Inno i.e. Sales_wo_Inno <> Sales - vSalesInno_Month as written in the expression
I know vSalesInno_Month is the right figure as I also put the full formula in another expression to check whether this was the issue, and the result shown is the exact same one as just writing =$(vSalesInno_Month) in the Expression box.
anyone any clue?
thanks a lot for your help!
I found : I have to add parenthesis for the variable and write
Sum({$<MonthDiff={0}>} [€ PUB])-($(vSalesInno_Month)) instead.
I found : I have to add parenthesis for the variable and write
Sum({$<MonthDiff={0}>} [€ PUB])-($(vSalesInno_Month)) instead.