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

Question

Question

Table calculation with another field Percentage

Forms Version 10
Updated August 10, 2023
asked on August 10, 2023

I have a use case where I have a "Total Cost" field that is populated with the total cost of a request.  Further down the form I have a table that allows the user to enter one or more commodity codes along with the value of each.  

I have an "Estimated Cost" and "Estimated percentage" field in the table.  

I would like the "Estimated percentage" field to calculate the percentage using the cost entered on that row, compared to the "Total Cost" field which isnt on the table.

I tried a few calculation methods and I cant seem to get it to work as intended.

 

=QUOTIENT(INDEX(variable.Itemized_Estimate_Costs_For_Each_Element.Estimated_Costs,ROW()),INDEX(variable.Total_Project_Cost))*100

 

0 0

Answer

SELECTED ANSWER
replied on August 10, 2023 • Show version history

Do you have a screenshot of all the fields? From your initial description it sounds like Total Cost is not part of a table, but your variables are set up in a way that indicates as though it is?

 

But this formula should work:

=(INDEX(EstimatedCost, ROW())/TotalCost)*100

0 0
replied on August 10, 2023

That's it. I did not need to have the INDEX function for the field outside of the table.  

Thanks!

1 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 ...