AnsweredAssumed Answered

Subsummary Help needed

Question asked by JimBrear on Nov 13, 2012
Latest reply on Nov 14, 2012 by JimBrear

I feel stupid asking this but I cannot work it out.


I am reporting services provided to clients. Service codes range from 01 to 22.


Depending on the age of the client the service will be Federal or state government funded.


I set up the report


I have a summary field Total services


Layout looks like this:


Sub Summary Service code leading


Sub Summary Jurisdiction (either Federal or State). % of this service code Total Services


Sub Summary Service code trailing % of Total Total Services


Trailing Grand Summary % of Total Total Services


For each Subsummary Juristiction I would like % of this service code to show what percentage of the total services for that service code each Jurisdiction represents. .


eg, Service code 1 has 100 services

Federal = 40

State = 60

I want the Sub Summary Jurisdiction Federal to show 40%

Sub Summary JurisdictionState to show 60%



How do I calculate the field % of this service code?


Thanks for your help on this.


Jim Brear