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

Question

Question

Force a formula to not calculate, or result of calculation populate, until field has a value

Forms Layout Designer Forms Version 11
Updated December 10, 2024
asked on December 10, 2024

Please see the screenshot below.

B and D populate with the factors listed in the formulas before anything is entered into A and C. As a result, E will give the totals of those values as well. If something is entered into A but not C, E still sums the factors in the formula of D to the result of B. This would be expected behavior.

I have tried only showing B and D if A or C have a value over $1.00 entered, that works for "showing" but does not change the behavior of the formulas.

How can I get B and D to calculate (or populate the result of the calculation) only if something, or something over $1.00, is entered in A or C? 

0 0

Answer

SELECTED ANSWER
replied on December 10, 2024

Have you tried IF functions in the calculation?

For Example,

=IF(INDEX(Table.Column,ROW()) > 1, PRODUCT(...), 0)

1 0
replied on December 10, 2024

I should have thought of that as I am using IF statements in other areas. It should work. Thanks, Jason! 

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...