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

Question

Question

Calculation subtraction in table does not work throws this error

Forms
Updated February 5, 2018
asked on September 12, 2017 • Show version history

The calculation options work fine when not working in tables and work fine when only adding columns together in both. But if you subtract the second variable, it throws this error.

=SUM(Table.Column_1,-Table.Column_2)

0 0

Replies

replied on September 12, 2017

Try this in your Column 3 function

=(INDEX(Table.Column_1,ROW())-INDEX(Table.Column_2,ROW()))

1 0
replied on September 12, 2017

Chad, while what I provided seems to make the calculations, I noticed that it still throws an error until you plug in the second number.

This one worked better for me, as it does not throw the error.

=SUM(INDEX(Table.Column_1,ROW()),-SUM(INDEX(Table.Column_2,ROW())))

0 0
View 1 previous reply
replied on September 13, 2017

Hey it works! I don't know what all the extra syntax means but that does fix the error. Thanks for your help!

0 0
replied on February 5, 2018 • Show version history

Raul, I'm trying to do similar to Chad. Mine is a multiplication that I'm trying to accomplish, to give a subtotal to an order form. Screenshot is attached. I modified your SUM syntax to MULT and applied it to the "Line Cost" column. My attempted syntaxes are below. 

 

=MULT(INDEX(Table.Quantity,ROW()),(INDEX(Table.Multiplier,ROW()))

=MULT((INDEX(Table.Quantity,ROW()),(INDEX(Table.Multiplier,ROW())))

=MULT(INDEX(Table.Quantity,ROW()),MULT(INDEX(Table.Multiplier,ROW()))

=MULT(INDEX(Table.Quantity,ROW()),-MULT(INDEX(Table.Multiplier,ROW()))

=MULT((INDEX(Table.Quantity,ROW()),MULT(INDEX(Table.Multiplier,ROW())))

 

I thought I understood the syntax, but obviously I'm grasping at straws. Any help you or anyone else can provide would be greatly appreciated.

 

 

Screen Shot 2018-02-05 at 14.20.02.png
Screen Shot 2018-02-05 at 14.20.02.png (59.81 KB)
Download
0 0
replied on February 5, 2018 • Show version history

Try this:

=PRODUCT(INDEX(Table.Quantity,ROW()),INDEX(Table.Multiplier,ROW()))

 

Also, make sure that your fields are set to "Number"

NumberFields.PNG
NumberFields.PNG (16.32 KB)
Download
0 0
replied on February 5, 2018

Raul, once I finally started thinking and realized that "table" needs to be the table variable I'm referencing, it worked like a champ. Both PRODUCT and MULT works. Thanks again!

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

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...