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 ...
EverettPatterso's avatar
EverettPatterso
Qrew Captain
6 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
------------------------------
EudonDelemar's avatar
EudonDelemar
Qrew Trainee
6 years ago
Thanks,

I think this is the right direction. The issue i have is as follows:
High Volume field is a text-multiple choice lookup field to get the yes or no answer
Surveyed printer field is also a lookup numeric field
Required printer field is Numeric field, user inputs number
Total New printers

Currently the Total new printer field has this formula
Surveyed printer field - Required printer field

So what i would need to happen is the following:
IF High Volume is Yes, do nothing, let the formula in total printers field subtract the 2 fields.
IF High Volume is NO, then Surveyed printer field - Required printer field /2 and that answer should go in the Total New printers field.

Hopefully this makes sense.

Thanks again

------------------------------
Mr Delemar
------------------------------
  • EverettPatterso's avatar
    EverettPatterso
    Qrew Captain
    6 years ago
    Use this formula for Total new printer, make sure your fields in [] are correct

    If(
[High Volume]="Yes", [Surveyed printer} - [Required printer],
[High Volume]="No", ([Surveyed printer} - [Required printer])/2)​


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