Calculation Condition - Custom Error Message

[#1]

Morning - I'm using calculated Condition to display a customer error message.  However, the custom message does not show consistently for all instances but only for one or two.....hoping it something simple....please let me know if I need to post additional information.

Thanks for the help!

[Gysbert_Wassenaar]

Your calculation condition sum([PVO 3rd Party USD]) will return a number. Any number that isn't 0 will be evaluated as True. Only a 0 result will result in the Calculation condition unfulfilled message.

[#3]

Thanks Gysbert - any quick ideas how to handle the null as well as the 0 in the same expression?

[Gysbert_Wassenaar · Accepted solution]

Try alt(sum([PVO 3rd Party USD]),0)

[prieper]

sum(.....) >= 0

edit: typo

Peter