So two things I am struggling with. First one is the more critical item which is pulling data through. I made a summary table so that I can create data on a report to put on my dashboard pages. I have two tables, one called Service Calls, and the other Punch List Items. Each one has an Age field as a duration type and is a formula field created by the formula Today() - ToDate([Date Created]). This appears to work perfectly as in my table I can see the age.
I created a relationship of Summary Table has many Service Calls and Summary Table has many Punch List Items.
In each of the relationships I created a summary field with average of the field Age. I made sure the summary field is filtering active only by filtering out when status is not equal to complete and status is not equal to cancelled.
I created a report showing each of these summary fields. And it says there is no data to show. Not sure where it is getting lost???
NEXT problem is when I do fix that I want to figure out how to color the font based on the number. So for example if age average is more than 5 days I need that one column to be a colored font (not color the entire row).
Thanks!
Question
Summary Table not Calculating Averages, and trying to color fields in the table
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.