Question

Forms 10 - Multiply Field Values

Updated April 17, 2016

asked on April 12, 2016

Trying to multiply a field value by another value, I've tried the following without success:

=SUM(Expense_Items.NumOfMiles*.55)

Also tried to use a hidden field with the value I want to multiply by:

=SUM(Expense_Items.NumOfMiles*MileReimbAmount)

0 0

Answer

SELECTED ANSWER

replied on April 13, 2016

It appears to be a couple of issues, Forms does not currently support calculations across values in a table or collection row.

So simple operators do work on single lines and number fields that are not in a table or collection - so this would be your formula for simple multiplication: =MyField*.55

Trying the same calculation on a field within a table does not currently work: =MyTable.MyField*.55

Simple addition does seem to work however on tables and collections: =SUM(Expense_Items.TotalCost)

0 0

Replies

replied on April 13, 2016

I think you need a val in there... something like:

=SUM(Expense_Items.NumOfMiles.val*.55)

you have to pull the actual value of the field out, not just refer to the css selector.

0 0

SELECTED ANSWER

replied on April 13, 2016

It appears to be a couple of issues, Forms does not currently support calculations across values in a table or collection row.

So simple operators do work on single lines and number fields that are not in a table or collection - so this would be your formula for simple multiplication: =MyField*.55

Trying the same calculation on a field within a table does not currently work: =MyTable.MyField*.55

Simple addition does seem to work however on tables and collections: =SUM(Expense_Items.TotalCost)

0 0

replied on April 17, 2016

I listened to the Webinar for 10.1 on Thursday, one of the improvements is letting you use calculations within table rows. :)

It's supposed to be out by the end of April.

1 0

You are not allowed to follow up in this post.

Question

Question

Forms 10 - Multiply Field Values

Answer

Replies

Sign in to reply to this post.