Gauge Report - Wrong Percentage
Hi! I'm creating a gauge report that shows the percentage of POs Invoiced/Current Project Budget (aka Percent Consumed). This report is going on a dashboard that has a dynamic filter for Project Pr...
Forum Discussion
Yes, I am doing the summary totals on a single universal reporting record.
Yes, I do have a field called [Percent Consumed] at the child level (Projects table). That field is a formula numeric-percentage field and the formula is
POs Invoiced/Current Project Budget
When I use that field in the report, all of the percentages are wrong. It's like it doesn't even look at the filters on the report. Then when it applies the dynamic filter for Project Priority, those percentages are all way off too. That's why I initially went with the idea of creating a formula for the report so I could specify what the percentage should be based on the priority choice. And it worked, except for when the priority is null.