Correct synax for variables in a table cell

[Bitmuster]

Hi all,

i have a table including several values and a date. I now want to sum up all values from the selected and the previous year. My formula for the previous year is wrong... What would be the correct syntax?

sum({<DATUM={(=day(DATUM)).$(=Date(DATUM, 'MM')).$(=year(DATUM)-1)},KST={"102101210"}>}NETTO) 

Thank you in advance and best regards

[PedroNetto]

Hi! You can use AddMonths(DATUM, -12) OR AddYears(DATUM, -1)

[Bitmuster]

Hi, 

but how?

=sum({$<AddYears(DATUM,-1),KST={"102101210"}>}NETTO) 

My formula is still broken.

Thank you!

[marcus_sommer · Accepted solution]

The left part within a set analysis must be always an existing field and the right part could be fixed values, search-strings, expressions or variables.

sum({<DATUM = {"$(=addmonths(DATUM, -12))"},KST={"102101210"}>}NETTO)