Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
I have a problem with the GetFieldSelections-Function. I would like the Month before the Selection (previous month)
That is my expression:
=Sum({<Monat={"$(=GetFieldSelections(Monat)-1)"}>}Plan)
The calculation of the currently selected month works
Could you help me?
Thank you very much!
Are you selecting a single month value? How did you create month field in the script, using month()?
Yes, a single month is always chosen.
Only there does the calculation need to work
... and i use Month()
Month(Datumsfeld) AS Monat,
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
---
Try formatting the dual to string for set comparison like:
=Sum({<Monat={"$(=Month(Date#(GetFieldSelections(Monat)-1,'M')))"}>}Plan)
Try formatting the dual to string for set comparison like:
=Sum({<Monat={"$(=Month(Date#(GetFieldSelections(Monat)-1,'M')))"}>}Plan)
...the part of the formula "-1" does not work for me. I think there is the problem. But I have no solution
=Sum({<Monat={"$(=Month(Date#(GetFieldSelections(Monat)-1,'MMM')))"}>}Plan)
Could you post a sample qvw?