You are viewing limited content. For full access, please sign in.

Question

Question

Why is IF statement showing up False?

asked on September 22, 2016

Why is this displaying a false value? After I perform a lookup, the value for Pay Hours Calculated gets updated to "Y". This statement should update the calculation to a "1" because it is a true statement.

0 0

Replies

replied on September 22, 2016

Can you provide more details regarding your scenario, specifically about how the fields may be related to each other? It looks like the "Pay Hours Calculated" field is in a table, but I'm not sure of the "Annual Pay Hours" field.

Here's an example using a table with three columns. The first column takes user input, performs a lookup and returns a value in the second column, and then based on that returned lookup value, the third column will use either 1 or 2. See below for the setup.

And here's a video demonstration.

1 0
replied on September 22, 2016

Looks Like I have to perform a SUM Function for Tables.

=IF(SUM(Variable="Y"),1,2)

replied on September 22, 2016

Could Laserfiche provide a response?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.