Chart in report

[marckk]

Hello,
I have a chart with 7 slices in a report, I have the labels displaying as percentages. What I need to do is dispaly an overall score next to the chart. This score is made up of three of the slices added together. So in this example [1 week, 2 weeks & Less than 1 week] all get added together to display 81%. I'm looking for a way to do that dynamically without having to manually update the number every week. Anyone have a suggestion or formuala to share?

 

[sxschech]

You could add a text box to the report containing the chart and create a dlookup or point to the data if it is already existing on a form. Example:

=DLookUp("FieldName","QueryName","Optional_WhereConditionFieldname='Value'")

If the data are already available such as on a form you could do:

=Forms!frmName.txtBoxName

Since it is not part of the chart, you can position it anywhere.

 

[marckk]

Many many thanks!