Different behavior between variable editor and code editor

stone1974 — Mon, 20 Dec 2021 21:08:46 GMT

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!

Re: Different behavior between variable editor and code editor

Taoufiq_Zarra — Wed, 09 Dec 2020 09:19:57 GMT

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

Re: Different behavior between variable editor and code editor

stone1974 — Wed, 09 Dec 2020 09:50:29 GMT

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

topic Re: Different behavior between variable editor and code editor in App Development

Different behavior between variable editor and code editor

Re: Different behavior between variable editor and code editor

Re: Different behavior between variable editor and code editor