Skip to main content

Hello, I’m trying to do a formula that calculates commision due. I have the commission field, and I also have a ‘commision paid’ checkbox field.

Basically I want the commission owing field to calculate the commission if the paid field isn’t ticked yes.

Help please!

Hi @czacza2007,

You can use this article to create your formula

Basically, it will be something like IF({Commission Paid} = 0, Commission, 0)

BR,
Mo


Hi @czacza2007,

You can use this article to create your formula

Basically, it will be something like IF({Commission Paid} = 0, Commission, 0)

BR,
Mo


Thanks Mo, that fixed it!