Skip to main content
L
lynnkehr77
Participant
May 9, 2016
Question

Calculating item codes

  • May 9, 2016
  • 1 reply
  • 318 views

I have a form that I cannot wrap my head around.

In the "Time" section on the left, there are a series of dropdown menus that correlate with the "Activity Codes" in the right column.

I need to calculate how many times a particular code appears in the "Time" section and multiply 30 (minutes) and then get a percentage for that particular activity over the week or 3,300 minutes.

As you can see the calculations for the "01 Face-to-Face Selling" is not correct because the "01" code appears 21 times for a total of 630 minutes.

In "02 Selling on the Phone", I manually typed in the number to show what I need it to do.  The "02" code appears 22 times for a total of 660 minutes.

I also need to make sure that the percentages add up to 100%

Is it possible to calculate this?

This topic has been closed for replies.

1 reply

G
George_Johnson
Inspiring
May 9, 2016

Sure it's possible If you provide information on the field names involved, it would be helpful. I'd suggest using just a single calculation script, as opposed to one of each calculated field. It would be responsible for calculating the values for all the fields on the right.

L
lynnkehr77Author
Participant
May 9, 2016

The field names on the left are labeled like this:

Day1_730, Day2_730, Day3_730, Day4_730, Day5_730

Day1_800, Day2_800, Day3_800, Day4_800, Day5_800

etc.

The "Total Minute" field names are:

AC1

AC2

AC3

etc.

The "% of Time" field names are:

time1

time2

etc.

I am not sure what you mean by a single calculation script (I am a newbie when it come to this) :-)  Could you provide an example?

Thank you for the quick response!

G
gkaiseril
Inspiring
May 10, 2016

Acrobat forms do not have specific order calculation so it is possible that as you create the form the order in which you want the calculations to occur will be used by the form. So then one either has to manually adjust the order of each calculation or write one script that sums all the activity codes using an array to accumulate each activity and then calculates the minutes for each activity and set the total for each activity.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices