Can I create average percentage column in reports

[abhilash.kumar.niit]

Hi ,
I'm using EspoCRM's reporting feature with the Advanced Pack. I need to add an average percentage column to my reports, and I'm also using grouping. How can I achieve this, and is it possible to group by columns and rows separately?

[lazovic]

Hi abhilash.kumar.niit,

Please tell me for which entity exactly are you creating a report? Does this entity have a field for calculating percentages? What numbers do you want to focus on?

[macistda]

You can use complex expressions within Grid Reports. To get an Average could be (example) SUMfield) / COUNT(field) and DIVa, b)

https://docs.espocrm.com/user-guide/complex-expressions/

[rohit.goel]

I have a report with a name of "Overall Quality Score (%) - Month Wise" and it has a following columns :-

Sum of fatal error
Sum of non fatal error
Sum of Total Defects
COUNT


and I want to add percentage column with name of "Quality Score %" against ((COUNT - Sum of Total Defects / COUNT) * 100) formula.