topic Using a variable in expressions in App Development

Using a variable in expressions

ecabanas — Mon, 14 Oct 2019 08:01:46 GMT

Hi,

I'm using a variable to calculate deppending on a field selected, this variable is named "Categoria".

I selected category "754" but using this function did not work.

Sum({<[SalesId]={"PV0***"},Catlevel2={$Categoria},CalendarYear_C = {"$(=max(CalendarYear_C)-1)"}>} Import_Brut)

But If I put instead of Categoria the value 754, the calculation is correct.

Sum({<[SalesId]={"PV0***"},Catlevel2={"754"},CalendarYear_C = {"$(=max(CalendarYear_C)-1)"}>} Import_Brut)

Thank's for your help

Eduard

Mauritz_SA — Mon, 14 Oct 2019 10:49:10 GMT

Hi there

You have to dollar expand your variable using $(variable). It seems as if you are missing the brackets.

Sum({<[SalesId]={"PV0***"},Catlevel2={$(Categoria)},CalendarYear_C = {"$(=max(CalendarYear_C)-1)"}>} Import_Brut)

Hope this helps.

Regards,

Mauritz

ecabanas — Mon, 14 Oct 2019 13:56:46 GMT

Thank's

GREAT!!!