Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to divide counts in report

annamkanton
Tera Contributor

Hi All,

 

I am preparing a report in which I need to calculate percentage of cases worked based on counts.

 

annamkanton_0-1721150422840.png

I want to do (28/2345) *100 and display as another column with the name percentage in the above pivot table how can I achieve that? OR is there any other report type I can make use of to achieve this?

 

And based on these percentages from 3 different pivot table reports, I need to create a new report that shows percentage over 3 months in different categories.

 

Any help would be much appreciated.

 

0 REPLIES 0