Participating Frequently

Question

Can someone help me if this is even possible.

Forum|Forum|2 years ago
June 23, 2023
3 replies
908 views

I have a PDF form that i have 3 columns however If column colums shown below:

What i want to do is %completed cumalitive can not exceed % of Total Job column but show cumulative total of the project less the % complete this period. I am not sure this is possible as i havent had any luck yet making it work

i have tried the below code with no luck

thank you in advance

Please let me know if this is not possible.

This topic has been closed for replies.

Bernd Alheit

Community Expert

At what field does you use this calculation?

R

Robert299561147m0xAuthor

Participating Frequently

thanks for your response the 3rd column does the calculation . but cant seem to get it to do the correct math. it is not supposed to exceed the column 1 amount

I think i am getting closer however as i mentioned above it can not exceed the column one amount

Bernd Alheit

Community Expert

Looks like that you use a recursive calculation.

Nesa Nurani

Community Expert

In what field do you use that script, and where did you put it?

R

Robert299561147m0xAuthor

Participating Frequently

thank you for the response the calculation is done in the 3rd column or % Completed Cumulative

Basically It supposed to track the column 2 progress up to the total of column 1 hope that makes sense

R

Robert299561147m0xAuthor

Participating Frequently

Additionally i dont know if it makes any difference but as you can see on the form the numbers are percentages. I wouldnt think it would change anything in the math but just not sure.

thanks again

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded