Nested IF - flag Script

[#1]

hi i am trying to achieve the following logic.

i would like to create a flag based on the following statement;

i seem to have a brackets issue however

=if (Artikeltyp = 'Z' and if (MovementDate > dayend(Now() -365)1, 0) ) as moving

[Gysbert_Wassenaar · Accepted solution]

Try:

if (Artikeltyp = 'Z' and MovementDate > addyears(today(1),-1) , 1, 0) as moving