Question

Have calculation ignore hidden fields.

Forms Version 10

Updated February 12, 2019

asked on February 6, 2018

Good Morning Everyone in Laserfiche Land!

So I have this table on my Travel Request form and it calculates meal per diem totals for travelers. Basically the traveler marks the meals that they are requesting a per diem advance for and when the form goes to the travel coordinator, the travel coordinator inputs the amounts for the meals the employee is requesting. The amount fields are hidden to the traveler but based on a look-up, will appear for the travel coordinator.

Basically the problem I am running into is let's say the traveler shouldn't have have selected to get reimbursed for dinner and the travel coordinator unchecked the dinner check-mark. This then makes the dinner amount a hidden field but the amount is still being calculated in the total. Is there a way to have the total ignore any of the hidden or unchecked fields above?

0 0

Answer

SELECTED ANSWER

replied on February 6, 2018

Hi Drew,

Calculations would not ignore hidden fields; instead, you can use SUMIFS function and check if the checkbox is selected before doing the sum, like this:

=SUM(SUMIFS(Table.Column_2, Table.Column_1.Breakfast, "=True"), SUMIFS(Table.Column_4, Table.Column_3.Lunch, "=True"), SUMIFS(Table.Column_6, Table.Column_5.Dinner, "=True"))

0 0

replied on February 12, 2019

What if I have a calculation that has a product? I'm trying to calculate approximate tax if it is applicable. I have a qualifying question on our purchase order form where staff can select whether tax applies for the purchase or not. If staff select "Taxable" (I then show the "Approximate Tax" field) I want the calculation to take the product. If staff select "Not taxable", the Approximate Tax field isn't showing and I want to calculation to not take the product. See attached. Thoughts?

Taxable LF Q.png (20.57 KB)

| Download

0 0

Replies

replied on March 9, 2018 • Show version history

You Rock Rui! I was overthinking things!

0 0

You are not allowed to follow up in this post.

Question

Question

Have calculation ignore hidden fields.

Answer

Replies

Sign in to reply to this post.