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

Question

Question

Trying to Multiply Variables from Table

Forms
Updated January 19, 2024
asked on March 11, 2019

Hello,

I am trying to Multiply two variables from the same table and I keep getting an error.  This is the formula I am using:

=MULT(Items.ItemsQty,Items.PriceItems)

Any ideas on why it wouldn't work?  Both variables are coming from a number field.

0 0

Answer

SELECTED ANSWER
replied on March 11, 2019

What error are you getting? Note that Table variables are arrays/collections, so that formula is trying to multiple two lists, not each "pair" individually.

Based on the naming of the variables, it looks like you need each row to multiply individually, in which case I would create a hidden column in the table that does the row by row multiplication, then get the sum of that column instead.

Each row would then have the following formula

=MULT(INDEX(Items.ItemsQty,ROW()),INDEX(Items.PriceItems,ROW()))

2 0
View 1 previous reply
replied on March 11, 2019

Hi Jason,

That worked.  

Thank you!

0 0
replied on July 11, 2019

Is there a way to multiple a variable in a table to a number? for example will the formula look like this:

=(INDEX(Items.ItemsQty,ROW()) * .59 ??

0 0
replied on July 11, 2019

Yes you can multiply a table row variable with a static number. What you have there should work, but you might want to try a MULT formula if you get any errors when the field is empty.

0 0
replied on January 19, 2024

Thanks that helped tremendously to use the INDEX :)

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...