2 Replies Latest reply on Mar 1, 2012 11:50 AM by cn2

    calculations in summary reports


      I have summary field that returns a count. In a report i have a subsummary part with a field projecttype which has a value of either "job" or "inquiry". In this same subsummary i'm trying to get what % were "jobs" and or what % "projects". How does this work? Thanks

        • 1. Re: calculations in summary reports

          Hi CN2,


          I put togther a little file to but I don't see an easy way to attach it to this email for you.


          I'll explain it for the count but you can do the same thing for the running count.


          Create a summary field called "COUNT" that gets you the count of all visible project types.

          Create a calcualtion as follows.


          Let (

                    [ count = GetSummary ( COUNT ; PROJECT_TYPE ) ; records = Get ( FoundCount ) ];

                    Round ( ( count/records ); 1 )



          If you want a percentage you have to know how many records that you have in all that is why we use Get ( FoundCount ) and Round to get you the percision you want it to resolve to.


          I'll create another topic and attach the file there.





          • 2. Re: calculations in summary reports

            Thanks for your time, just what i needed.