sephan

No sorry, I guess you have not caught the problem. I already did all of that.

My problem: Due to the equation, my result goes wrong when a number field is not filled out, because i want only the filled fields to be calculated. Equation example short:

((fieldname1-209)/18.4)+((fieldname2-14)/1.15)+((fieldname3-16)/1.17)

Example: Now to make my problem clear I use a small example with 3 fields:

Let’s say I fill out “fieldname1” and “fieldname2”. “fieldname3” stays empty.
Now, when I start the calculation, the equation just goes: ((fieldname1-209)/18.4)+((fieldname2-14)/1.15)+((0-16)/1.17)

The problem ends up in: Empty fields will cause a false result because the result will be subtracted by the equation of the empty fields.

To prevent this: I started to use predefined values, but in dropdown menus, only the chosen option is calculated.

Solution: I want to make the predefined value of unchosen fields count.

Condition: In the end, I will have 10 number fields, each mentioned within the equation like in the example above, but the user will only fill out 4 of these fields, depending on their own conditions.

• This reply was modified 4 years, 10 months ago by sephan.
• This reply was modified 4 years, 10 months ago by sephan.
• This reply was modified 4 years, 10 months ago by sephan.
• This reply was modified 4 years, 10 months ago by sephan.

Oh and I actually got two other questions. I would like to put a frame around the table but only on mobile view. And secondly, is it possible to exclude the filter section from scrolling? To sort of make them static? Would that be possible as well?

Thank you for your great work on that project!
Stephan.

• This reply was modified 5 years, 1 month ago by sephan.
• This reply was modified 5 years, 1 month ago by sephan.

Worked great!