Percent of data in field

[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 sorting on a different field. Can you help please?

 

[sclark415]

Is the easist way to do this by If-Then-Else, If FieldAdjuster = 'A' then A
Else
Is the easist way to do this by If-Then-Else, If FieldAdjuster = 'B' then B

and so on - then I can divide total Claims by A, then B and so on?

 

[sclark415]

I recreated this question... I have this one so conveluted that it is hard to understand what I am asking. If you came to this question to help me out, I appreciate it.. Thanks

 

[Madawc]

I've got 8.5, but anything I can do should still be possible in Crystal 10.

It depends on how many types of FieldAdjuster. If it is only 3 or 4, do a running total for each. In the report footer, separately calculate a percentage for each. Allow for zero results.

If it is a lot, you could group by FieldAdjuster. Calculate a total for each group against a summary total for the report. If this gets in the way of other stuff you need to report, put this function into a subreport in the report header or report footer.


Madawc Williams (East Anglia)