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

Discussion

Discussion

Multiple Calculation within a Table

Forms Version 10
Updated September 5, 2018
posted on August 31, 2018

I am looking to calculate a currency amount based on a drop-down field field within a table.  I am getting a calculation error.  I have tried various things based on other posted questions/answers.  I do not know how to do calculations well. 

Quantity of Days (Drop-down) * $150 = Amount (Currency $)

Please help! (below is my current formula)

0 0
replied on September 2, 2018

Hello Vanessa,

 

please try the following formula :

 

=MULT(INDEX(Directors_Work_Table.V__of_Days,ROW()),150)

 

it should work.

Maher.

3 0
replied on August 31, 2018

Hi Lidija,

I tried what you posted above and verified that the drop-down field has numerical values assigned.  Now I get the following error (see image below).  Any suggestions? 

Thank you,

Vanessa Huynh

0 0
replied on September 4, 2018 • Show version history

=(MULT(INDEX(TableThatYouWantToPull.Column, RowNumber), 150)

 

Sorry!

Maher's way works well too because the "Row()" command will calculate the value for each row - this depends on where your calculation is at. If your output calculations are inline (same table) then you want to use the "ROW()", if you want the output of a specific row in a Number Field then you can use what I suggested. Play around with it to see what works best for your situation.

2 0
replied on September 5, 2018

Thank you Lidija!  I ended up using Matthew's formula because I had 25 rows to calculate. smiley

0 0
replied on September 5, 2018

Great, you can mark his reply as the Answer to your question :) Thanks!

0 0
replied on August 31, 2018

Vanessa, Try this:

=MULT(INDEX(Directors_Work_Table.V__of_Days, 150))

 

You had an extra closing parenthasis where you didn't need it it looks like.

If that doesn't help, make sure that the dropdown is a number or set the value (after it is selected) into a number field. 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...