Good afternoon all,
I have a simple question. I am trying to use a gauge on my report. The report is a detail item report for a patient with all the cost associated with the case. I think would like to see what the cost ration is so I take my total cost and divided them against the total charges, I have created a Formula Field for this and I am getting the data as expected of 0.17 for this one case. I want to place that value on the gauge to show how it falls in line. I want to show that value on the gauge, but when I try and add the data field I created it wants to summarize it using Sum, Count, Average. I do not need any of those as I have the value I want. How can I get that value on the gauge? I would also like to start the gauge color with green from 0 to 20 then change it to orange from 20 to 70 and then red for 70 to 100.