Skip to main content

Right now we have a formula that uses percentages based on timeliness (Auto Calculated Percentage). This value is determined through a set of time between two dates. However I’d like to be able to override that for certain employees using another field like a checkbox or maybe a number field. So maybe an if statement would go in the auto calculated percentage? Like if override field is blank then use auto calculated percentage field? I can’t figure out how to do it


({Payment from Customer}*({Auto Calculated Percentage}/100))-{Admin Fee}-{Insurance Fee}-{Amount Paid to Employee}

Hi @F_M!


IF() formulas work as follows:


IF({condition is true/has a value},

   {do this},

   {otherwise do that}

)

In your case you need to create your new field of choice and then add an IF() statement to your original formula. This should do it.


IF({name of new field of choice},

    	{name of new field of choice},

    	{Payment from Customer}*({Auto Calculated Percentage}/100))-{Admin Fee}-{Insurance Fee}-{Amount Paid to Employee}

)

(You have a random ‘(’ at the beginning of your formula. Check to see if this is a mistake just in your question post or if not all of your original formula was copied. Make sure that you use the whole of the original formula in your IF()-statement for it to work as desired.)

Reply


Terms & Conditions