IfNUll on another column

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.

Any suggestions?



Pavan Kumar

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Pavan,

    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)

Like Follow
  • Status Answered
  • 6 mths agoLast active
  • 1Replies
  • 19Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!