February 12, 2015 at 1:28 am
Hello
I currently run a report and show, in a table, the % of calls answered within 15 seconds. I do this via an expression:
=count(fields!callno.Value)/ReportItems!Textbox10.Value*1)
This works fine in a table. However, when I insert a chart (I would like to show this % over the last 3 months), and add this expression to values, the number returned on the chart does not reflect the % figure that appears in the table, e.g. the calculation in the table will say 67%, in the chart the number '1' appears.
When I add the above expression to a text box the value 'infinity' appears.
So clarly I'm doing something wrong. My first question is can I just copy an expression over from a table and put it in a chart, or do I need a separate expression for the chart? Any pointers towards this would be hugely appreciated.
Hopefully this is enough detail but can add more if needed.
Many thanks.
February 12, 2015 at 3:06 pm
Sorted this by creating calculated fields and selecting them to chart with.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply