Announcement

Collapse
No announcement yet.

Trouble with Formula

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Trouble with Formula

    Hi All,

    I have tried my hardest to deal with a simple enough formula, but cannot get the formatting correct for it to generate what I need.

    I have a quantity parameter which I need to mutiply the amount by, depending on whether the LHS or RHS is on or they are both off. So I have 3 scenarios:

    • Both on, which would require the quantity parameter to be x by 2.
    • 1 on and 1 off, which require the quantity parameter to be x by 1. I.e no change from the quantity number
    • Both off, which requires the quantity parameter to return a 0.


    Can anyone help create the correct formula for this?

    Cheers

    #2
    LHS (Y/N)
    RHS (Y/N)
    Q_calc (Area) (where your family is reporting it's original number)

    LHS_factor (number) if(LHS,1,0)
    RHS_factor (number) if(RHS,1,0)
    factor (number) = LHS_factor+RHS_factor

    Q_report (Area) = Q_calc * factor

    could be a bit less parameters if you nest the formula's.

    Comment


      #3
      Originally posted by Bjorn_K View Post
      LHS (Y/N)
      RHS (Y/N)
      Q_calc (Area) (where your family is reporting it's original number)

      LHS_factor (number) if(LHS,1,0)
      RHS_factor (number) if(RHS,1,0)
      factor (number) = LHS_factor+RHS_factor

      Q_report (Area) = Q_calc * factor

      could be a bit less parameters if you nest the formula's.
      Thanks, I shall try this now!

      Comment


        #4
        Boom, it worked.

        Solved. Simplifiying is key!

        Comment

        Loading...
        Working...
        X