Skip to Content
0
May 10, 2020 at 12:43 PM

If AND function

44 Views

Hi guys

I am trying to write a variable with the following logic but cant seem to get it to work, can anyone help?

I am not sure about the brackets etc

If [Maternity?] = "n" then ""

else if

[Maternity?] = "y" AND [Mat Date] <= [current date] then "0" else [FTE]

thanks

Will