Sum of selected year

[reporting_neu]

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?

[rubenmarin]

Hi, change IA_Statistik.Year={"=$(=Num(Year(Today())))"}

to: IA_Statistik.Year={"=$(=Max(IA_Statistik.Year))"}