Skip to main content
Question

Selecting a yes/no field and dividing a result.

  • September 10, 2019
  • 0 replies
  • 32 views
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 Yes/No question and if the answer is NO, then it will need to divide the number in the Total printer required field by half.

Fields currently:
High volume site - Yes/No
              If NO then divide the number in the "Total printers required field"
              IF YES then do nothing
Total printers required field  ( this is a formula field that subtracts from 2 other fields to get the totals.)

How will i tell QB if the NO answer is selected then cut the number in the Total printer required field in half and return the result in the same Total printers required field?

Any help will be greatly appreciated, I believe part of the issue is the fact that i have text and numeric formula fields.

Thanks in advance.

------------------------------
Mr Delemar
------------------------------
    This topic has been closed for replies.

    EverettPatterso
    Forum|alt.badge.img+10
    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
    ------------------------------
    AdamKeever1
    Forum|alt.badge.img+2
    • AdamKeever1
    • Registered
    • September 10, 2019
    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
    ------------------------------
    Terms & ConditionsAccessibility statement