I am working with a report of tickets and I am trying to calculate the number of tickets for each date and the number of tickets completed with issues . Is there a way to create a field in the table or use a report formula to perform these calculations?
------------------------------
Paul Peterson
------------------------------
Question
Report Formula Question
This topic has been closed for replies.
+24I suggest that you make a formula called [Ticket had Issue count]
Then make a formula numeric field which calculates to either a 1 or a 0 depending on it if had an issue or not.
Then use that field in a report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Then make a formula numeric field which calculates to either a 1 or a 0 depending on it if had an issue or not.
Then use that field in a report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.