Percent Total in Group Footer

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

  • 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
  • Replied 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
  • Replied 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
  • Replied 13 April 2020, 1:01 am EST

    Hello,

    Please refer to the attached report to achieve your requirements.

    Thanks,
    Mohit
    Untitled.zip
  • Replied 18 April 2020, 12:48 am EST

    Thank you for the sample. It worked perfectly
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels