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
if (Artikeltyp = 'Z' and MovementDate > addyears(today(1),-1) , 1, 0) as moving
Retrieving data ...