Forum Discussion

EudonDelemar's avatar
EudonDelemar
Qrew Trainee
6 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 ...
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
I would change your "Total printers required field" to just "Total printers". Then add a formula field called "Required printers"; this will be the field you would use to monitor the number of required printers based on the yes/no selection. Then use your IF logic in the "Required printers" field:

 
IF(
[High Volume] = true,
[Total printers] / 2,
[Total printers]
)


------------------------------
Adam Keever
------------------------------