I am trying to run a formula that only runs if a field is checked. Basically, if the field is not checked I want the formula field(currency) to be $0. If it is checked I want it to run a calculation based on another field.
I have tried:
If(${Sales Orders.Commissionable}==0,0,If(${Sales Orders.Term}=='one (1) month',${Sales Orders.ARR}*0.8333333333,${Sales Orders.ARR}))
On this I get an error that it is not the right data type. Makes sense the field is currency.
If(${Sales Orders.Commissionable}==false,0,If(${Sales Orders.Term}=='one (1) month',${Sales Orders.ARR}*0.8333333333,${Sales Orders.ARR}))
I tried this and got the same data type error.
If(Tonumber(${Sales Orders.Commissionable})==0,0,If(${Sales Orders.Term}=='one (1) month',${Sales Orders.ARR}*0.8333333333,${Sales Orders.ARR}))
This passed the syntax check but always acted as if the checkbox was unchecked always returning a 0.
How can I fix this formula to work?