Calculating item codes


i have form cannot wrap head around.

adobe_forum_code_calculation.png

 

in "time" section on left, there series of dropdown menus correlate "activity codes" in right column.

 

i need calculate how many times particular code appears in "time" section , multiply 30 (minutes) , percentage particular activity on week or 3,300 minutes.

 

as can see calculations "01 face-to-face selling" not correct because "01" code appears 21 times total of 630 minutes.

in "02 selling on phone", manually typed in number show need do.  "02" code appears 22 times total of 660 minutes.

 

i need make sure percentages add 100%

 

is possible calculate this?

sure it's possible if provide information on field names involved, helpful. i'd suggest using single calculation script, opposed 1 of each calculated field. responsible calculating values fields on right.



More discussions in PDF Forms


adobe

Comments

Popular posts from this blog

Soustraire une selection

After Effects: could not find dvaeve_dialogs.txt

Illustrator cs6 "Invalid Serial Number"