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 Priority. After lots of trial and error, I decided to create summary fields in a parent table called "Universal Reporting Record". The summary fields specify the percentage for each priority... 1, 2, 3 and the combination of all three as All. I am then using a formula in the gauge report to specify which Percent Consumed field should be used depending on the priority: The percentage for "All" should be 13.4%, but it continues to show 17% and I cannot figure out why. The other priorities (1, 2, and 3) show correctly as the dynamic filter is changed. The calculation is done on $s Consumed/Total Budget. These are the same fields used in the summary table mentioned above, just different labels for the dashboard. Here are the results for Project Priority = 1 which are correct: Any help is greatly appreciated!!86Views1like8CommentsSort & Group separate from UI
Hi, There are a lot of instances where we need the users to be able to sort and group their reports, but we can't leave the report open for editing. I've opened a ticket to see if Quickbase can separate out the Sort & Group feature from the User Interface settings. If you're interested in this too - go "request actions" and subscribe to the ticket Sort & Group #409577 - this is a link to the feedback: Request | Feedback (quickbase.com)11Views1like0Comments