How do I get result 0 instead of Null when I set up my formula. For example this is my formula, how can I replace the nulls with zeros?

(SumIf([Amount], (In([Stock Id], “21975”) and (In([Company Name], “Purus Gravida Limited”))))

How do I get result 0 instead of Null when I set up my formula. For example this is my formula, how can I replace the nulls with zeros?

(SumIf([Amount], (In([Stock Id], “21975”) and (In([Company Name], “Purus Gravida Limited”))))

1 Like

Hey Zachary!

You can use the Coalesce formula for this case! So for this example you can use this formula.

Coalesce(SumIf([Amount], (In([Stock Id], “21975”) and (In([Company Name], “Purus Gravida Limited”)))), 0)

1 Like