Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used a formula that has only ever worked for the current year.
Now I would like to have this calculated depending on the selected year (field: MASTER_CAL.Year).
The current status is that the formula calculates a value from the last 6 months. It should stay that way. However, the calculation should depend on the year selected.
SUM({IA_Statistik.Periode={">=$(=Num(Month(Today())-5))"}*{"<=$(=Num(Month(Today())-1))"}, IA_Statistik.Year={"=$(=Num(Year(Today())))"}>}Sales)
Can you help me?
Hi, change IA_Statistik.Year={"=$(=Num(Year(Today())))"}
to: IA_Statistik.Year={"=$(=Max(IA_Statistik.Year))"}