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

Question

New Forms Designer: Sum of table column does not work on iPhone

Forms

Updated November 15, 2023

asked on November 15, 2023

I have a table with an Amount column (Currency) and a Total field (Currency) outside of the table. The formula is: =SUM(GL_Coding.Amount). The Total field works fine when in Chrome on my PC, but when I open this form on an iPhone, either in the app or in Chrome, the Total field does not calculate. I have tested this on two iPhones in both the LF app and in Chrome.

Please advise. Thank you.

IMG_0450.jpg (203.07 KB)

| Download

0 0

Answer

APPROVED ANSWER

replied on November 15, 2023

Ok, I figured it out. The Amount column in the table had the following formula:

=INDEX(Invoice_Amount * INDEX(GL_Coding.Pct_Total,ROW()) / 100

This works fine on PC but doesn't work on iPhone for some reason. I updated it to the following and now it works:

=IF(
INDEX(GL_Coding.Pct_Total,ROW()) >0,
Invoice_Amount * INDEX(GL_Coding.Pct_Total,ROW()) / 100,
Invoice_Amount

)

0 0

replied on November 15, 2023

Interesting, I will look into this. Ref #496351

1 0

Question

Question

New Forms Designer: Sum of table column does not work on iPhone

Answer

Replies

Sign in to reply to this post.