Sum with variable not showing the expected result

Delphines — Thu, 27 Jun 2024 15:17:07 GMT

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:

a variable called vSalesInno_Month defined as
Sum({$<MonthDiff={0}>} if(LaunchDate>=$(vInnoStartMonth),1,0)*[€ PUB])
Sales as Expression in my chart
= Sum({$<MonthDiff={0}>} [€ PUB])
Sales_wo_Inno as Expression in may chart
= Sum({$<MonthDiff={0}>} [€ PUB])-$(vSalesInno_Month)

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!

Re: Sum with variable not showing the expected result

Delphines — Thu, 27 Jun 2024 15:53:10 GMT

I found : I have to add parenthesis for the variable and write

Sum({$<MonthDiff={0}>} [€ PUB])-($(vSalesInno_Month)) instead.

topic Sum with variable not showing the expected result in App Development

Sum with variable not showing the expected result

Re: Sum with variable not showing the expected result