Percent Total in Group Footer

Percent Total in Group Footer

Posted by: kristy on 8 April 2020, 2:29 am EST

• 

  kristy

  • Post Options:
  • Link
    Copy

  Posted 8 April 2020, 2:29 am EST

  I have a code based section report (v 13). In the Group Footer I have a summary field which is a count of the field jobid for the group. I would like to have a calculated field in the group footer which shows Percent of Grand Total for the jobid count. Is there a way to do this?

  Thank you

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 9 April 2020, 6:24 am EST

  Hello,

  Sorry to mention that could you please explain your requirement in little bit more detail.

  Thanks,
  
  Mohit

• 

  kristy

  • Post Options:
  • Link
    Copy

  Posted 10 April 2020, 7:43 am EST

  I’m going to modify my report so the calculation I want is now in the report detail

  How can I calculate a percent total in the report detail?

  For example:
  
  User: Job count %Total
  
  Jane Doe 24 63% (report detail) (24/38)
  
  Jack Black 14 37% (report detail) (14/38)
  
  Grand Total 38 (report footer)

  Thank you

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 13 April 2020, 1:01 am EST

  Hello,

  Please refer to the attached report to achieve your requirements.

  Thanks,
  
  Mohit
  
  Untitled.zip

• 

  kristy

  • Post Options:
  • Link
    Copy

  Posted 18 April 2020, 12:48 am EST

  Thank you for the sample. It worked perfectly