Need assistance with Formula referencing field outside and inside a table

asked on June 12, 2024 • Show version history

Good afternoon. I am attempting to gather the percentage of the value of a Number field Outside a table by comparing it with a value inside the table and the writing the results inside the table.

Details:

Prod Qty is a number field with variable "Prod_Quantity"

The Table is called "My_Time" with (2) fields inside involved: Qty Comp & % Comp.

Qty Comp is a number field with variable "Quantity_Comp"

% Comp is a number field with the variable "Percentage_Complete"

The % Comp is the field that contains the formula:

=DIV(INDEX(My_Time.Quantity_Comp,ROW()) , Prod_Quantity)

Currently I don't get any errors, but the % Comp value stays at '0'.

If the math worked, I would get 0.2. So, I would want to move the decimal over so it reveals '20'.

Visual example.png (11.84 KB)

| Download

0 0

SELECTED ANSWER

replied on June 12, 2024

A couple of questions before I dig too deep:

Have you set your % Comp field to show decimals? If not, that is likely why it is still displaying 0 as it would round down from 0.2. Seeing as it's showing as 0 and not 0.0, I'm guessing this is the issue.

Alternatively, since you said you're wanting it to display as 20 (%) instead of 0.2, you should adjust your calculation to multiply by 100. (In this case you don't need decimals.)

If that doesn't help I can try and look into the formula itself, but I wanted to confirm these points first.

0 0

replied on June 12, 2024

That was the solution. Then to get the decimal in percentage value, I just added the *100 at the end of the line.

Thank you!

1 0

replied on June 12, 2024

Perfect, happy to help! (And glad it was something simple!) :)

0 0

Question

Question

Need assistance with Formula referencing field outside and inside a table

Answer

Replies

Sign in to reply to this post.