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

    calculations in summary reports

    cn2

      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
          vince.menanno

          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.

           

          Enjoy.

           

          Vince

          • 2. Re: calculations in summary reports
            cn2

            Thanks for your time, just what i needed.