Can you help PLEASE??? Percent question 1

[sclark415]

Hi, I am on V10 - I have a field called FieldAdjuster. I have to figure the percentage of different field adjusters to the total claims on the report. I am not able to sort on the FieldAdjuster field.

I created formulas for each adjuster
If FieldAdjuster = 'A'
Then 'A'

If FieldAdjuster = 'B'
Then 'B' and so on

I then listed each in a report footer, tried to get counts of each - if I use 'count' I get the report count, if I use 'distinct count' I get one.

Can you tell me what I am doing wrong? I have yet to get percents on each adjuster, since I can't even get counts.

 

[jdemmi]

Have you tried using the running total function?

From the VIEW menu, choose FIELD EXPLORER. RUNNING TOTAL should be on the list.

 

[sclark415]

Thank you for your help. I haven't used this field before. Since I can't group by the Adj field, I will need to play witht the reset part of the box so I can get my Adj. totals.
Thanks again for your help!

 

[lbass]

You could take your first approach, and change your formulas to:

If FieldAdjuster = 'A'
Then 1

Then right click on this formula and insert a summary (SUM, not count) at the group and report levels. The reason your initial method didn't work was because a count counts the number of times the formula executes.

Using the running total method, you would have to have a running total for each field adjuster, with an evaluation formula:

{table.fieldadjuster} = "A"

Conditional formulas will result in a speedier report than one using running totals, but will be about the same amount of effort.

-LB