Skip to main content
Question

Summary Table not Calculating Averages, and trying to color fields in the table

  • July 27, 2019
  • 0 replies
  • 105 views

Forum|alt.badge.img+11
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!

  • Registered
  • July 29, 2019
Ivan - Based on the information you've provided (and without me knowing a lot about your end goal) it sounds like you may need to revisit your approach. I'm guessing that a single Service Call could have many Punch List Items. If this is indeed the case, you would need to setup a relationship between these two tables and then do a Summary field from Punch List Items to Service Calls. You can then build a Summary Report on the Service Calls table to see the information you're looking for.