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

Question

form field calculation

Forms Business Processes Laserfiche Cloud Forms Layout Designer How To

Updated March 4

asked on March 2

Good Day all

So i am trying to automate the calculation for the Total and unit total but when i add a new row, instead of calculating for that row, it calculates everything in any of the selected fields i want to calculate.

0 0

Answer

SELECTED ANSWER

replied on March 2

When calculating within the ROW, as in the Unit Total, the format for the Unit Total is
=MULT(INDEX(Items.Quantity,ROW()),INDEX(Items.UnitPrice,ROW()))

INDEX(tablename.Fieldvariablename,ROW())

3 0

replied on March 4

Hi Steve, thank you

I used this, and it worked

0 0

Replies

replied on March 2

Can you show us how your formulas are set up?

0 0

replied on March 3 • Show version history

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked March 2
Updated March 4
171 views