Boom, it worked.
Solved. Simplifiying is key!
-
Thanks, I shall try this now!Originally posted by Bjorn_K View PostLeave a comment:
-
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:
-
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
Leave a comment: