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

Question

Question

Sum formula not working in Table

Forms
Updated May 23, 2019
asked on May 22, 2019

We are having issues with a SUM formula on a table used in one of our Forms. Here is the sample formula I replicated to test the issue myself: =SUM(INDEX(tst_sum_Tbl.wk_1,ROW()),INDEX(tst_sum_Tbl.wk_2,ROW()),INDEX(tst_sum_Tbl.wk_3,ROW()),INDEX(tst_sum_Tbl.wk_4,ROW()))

Total field where the formula exists does not calculate the total.

 

0 0

Replies

replied on May 22, 2019

Are you using Number fields?

0 0
replied on May 23, 2019

Yea number fields and getting a calculation error now that I have changed it. Do you know where or how I can determine what the calc error is?

0 0
replied on May 23, 2019

When you go into the designer and look at the calculation it should tell you whether it is a syntax error or a problem with a variable, assuming there's actually a problem with the calculation itself.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...