Can anyone help me how to write if statement in load script. I try below script and get error.
End If as Sale,
If(Condition, then, else)
The three parameters condition, then and else are all expressions. The first one, condition, is interpreted logically. The two other ones, then and else, can be of any type. They should preferably be of the same type. If condition is true, the function returns the value of the expression then. If condition is false, the function returns the value of the expression else.