I have two columns ie Sales, Profit.
So, my requirement is if Sales is Null then 0 else if Sales not Null Profit.
I tried using IfNull and IsNull functions but no luck.
You can use a combination of the IF and IsNull functions. IsNull returns a boolean (true or false) which you can use in the IF function.
So, for your example, the formula would be: IF(IsNull(Sales), 0, Profit)
© Incorta, Inc. All Rights Reserved.
Incorta 4.9 is now Generally Available (GA)!!!