Forum Discussion

WilliamBelfast's avatar
WilliamBelfast
Qrew Member
7 years ago

How to calculate a percentage on a Summary Report?

I have a table to track work tickets.  I want to be able to run a monthly summary report which shows the percentage of work tickets completed by type.  Basically just [completed tickets]/[total ti...
Formulas and functions
reports and charts
BarbaraAlvarez1's avatar
BarbaraAlvarez1
Qrew Member
4 years ago
I know this thread is quite old, but I needed the same type of logic that the OP was looking for.   I followed the instructions and it worked to a tee except when changing my text field back to a text formula.  The error says you cannot have a formula field as a summary field in a relationship.   Is this a new rule since this thread was written?  Is there a way to get around that?  

Thank you

------------------------------
Barbara Alvarez
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Barbara,
This is, as you said,  a very old thread. 

There are newer and potentially much easier solutions now.   I suggest that you post a new question, perhaps referencing this post but still fully describing your situation and question and myself and others will watch for it. 

You may be able to solve this simply using what are called summary formula fields in a Summary Report Type. 



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------