Different behavior between variable editor and code editor

[stone1974]

Hi!

I have formulars to get a selected data and then the month before.

SET vSelectedDate = Date(GetFieldSelections([FiscalPeriods.CalendarYear]) &'-'& GetFieldSelections([FiscalPeriods.CalendarMonth]) &'-1');

SET vSelectedMonth = "$(=Num(Month($(vSelectedDate))))";

SET vSelectedMonthMinus1 =  "$(=Num(Month(AddMonths($(vSelectedDate),-1))))";

SET vSelectedYear = "$(=Num(Year($(vSelectedDate))))";

SET vSelectedYearMinus1 = "$(=Num(Year(AddMonths($(vSelectedDate),-1))))"

SET vValue = (Sum({$ <PLI.TEST={"TEST"}, [FiscalPeriods.CalendarYear]={$(vSelectedYear)}, [FiscalPeriods.CalendarMonth]={$(vSelectedMonth)}>} PLI.Value))

The code is working fine if I put it in the variable editor but if I put it into the code editor its not working anymore. WHY? Any hints r welcome 😊.

Thank u very much!

[Taoufiq_Zarra]

 @stone1974  how do you use this variable in an editor ?

[stone1974]

Hi,
At the end, I just use the vValue as $(vValue).
Regards,
Michael