Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@stone1974 how do you use this variable in an editor ?