Skip to Content
0
Former Member
Jun 22, 2013 at 06:13 AM

Blank Pie Chart using Formulas

63 Views

Hello All:

I have a subreport that has two pie charts. The first one works as expected. I need to use a calulation in the second chart - when I do the chart is blank. I placed the calulated value next to the chart to make sure it is calulating the correct value, which it is. I used calulated values in the first chart and it works so I am puzzled by the second chart not working. If I just use field values from the table (no calulation) then the second chart works. The calulation is taking a field value (Billings) and subtracting a calculated value for Sales Tax. The chart should include the field for actual cost and the adjusted income (billings - sales tax). If I use the actual cost field and the billings field, the chart shows - the percetages are just wrong because the billings need adjusted for sales tax. If I use a formula to create the adjusted income, then the pie chart is blank. Anybody have any ideas why it would do this? Any help is appreciated.