Question

Form Table Calculation Error

Forms

Updated July 31, 2016

asked on July 28, 2016

Using the forms calculator in table. I am getting the result on the Total Price. Equation on Total price is the following:

= Table.Price_per_lb * (Table.Total_Weight - Table.Bucket_Weight)

I am expecting the result to give: = 3.20 * (200.00 - 100.00)

Is there a way to troubleshoot more than just getting a calculation error message from the field in question? It's too vague to work with.

0 0

Replies

replied on July 31, 2016

Hi Chase,

Somebody may have a cleaner approach than this, but try this:

=SUM(INDEX(Table.Price_per_lb,ROW()) * (INDEX(Table.Total_Weight,ROW()) - INDEX(Table.Bucket_Weight,ROW())))

I've got it working in the Total Price column (Currency data type):

Cheers,

Mike

2 0

replied on July 29, 2016

Are all 3 fields number fields or a mix of different field types?

0 0

replied on July 29, 2016

All 3 are number fields correct. I didn't show multiple rows though.

In this example there are 5 rows.

I expected it to work as such:

Row1: = Table.Price_per_lb * (Table.Total_Weight - Table.Bucket_Weight)

Row2: = Table.Price_per_lb * (Table.Total_Weight - Table.Bucket_Weight)

etc.

Where each row calculates individually. Is the calculator trying to sum all the Total_weight and all the Bucket_weight with the sum of all price_per_lb?

0 0

You are not allowed to follow up in this post.

Question

Question

Form Table Calculation Error

Replies

Sign in to reply to this post.