Announcement

Collapse
No announcement yet.

Trouble with Formula

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

  • gioginnelli
    replied
    Boom, it worked.

    Solved. Simplifiying is key!

    Leave a comment:


  • gioginnelli
    replied
    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!

    Leave a comment:


  • Bjorn_K
    replied
    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.

    Leave a comment:


  • gioginnelli
    started a topic Trouble with Formula

    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

Related Topics

Collapse

Working...
X