I'm having trouble with a simple pie chart that I want to have in a report.
I'm not using modern charts.
The chart is fed by a table, FundingTypeCHART_T shown below.
The pie chart displays as numbers only. I want this in currency.
The row source for the chart, shows the currency, see below.
Opening the chart editor, I can change the format to currency for the Funding Amount column, but it converts back to a number once I save and open the report.
How can get this chart to show the currency symbol, $?
I'm not using modern charts.
The chart is fed by a table, FundingTypeCHART_T shown below.
The pie chart displays as numbers only. I want this in currency.
The row source for the chart, shows the currency, see below.
Opening the chart editor, I can change the format to currency for the Funding Amount column, but it converts back to a number once I save and open the report.
How can get this chart to show the currency symbol, $?