Forum Discussion

EudonDelemar's avatar
EudonDelemar
Qrew Trainee
7 years ago

Selecting a yes/no field and dividing a result.

My current issue is I have a field that calculates the total number of printers needed per site (Total printers required field).  That part works fine. Now I need to add an additional field that is a ...
EverettPatterso's avatar
EverettPatterso
Qrew Captain
7 years ago
Update your formula field to include an IF statement

If(
[High volume site]="No", ([some field]-[some field])/2,
[some field]-[some field])

post your actual formula if you need help adding the IF statement

------------------------------
Everett Patterson
------------------------------