I have a simple pie chart showing the size of quoted projects with the Quoted Price column (set as a Price type). The name of the potential Sales Opportunity is set as the key. The view produces the correct numeric figures but not in currency format. I tried a virtual column where I CONCATENATE the Quoted Price with a dollar sign:
CONCATENATE(“$”,[Quoted Price])
And the test results of this produces the amount with the correct format that has a dollar sign, but with no commas. When I make a pie chart view refer to that virtual column, there is still no dollar sign (or commas) in the chart view (I.e., a $250,000.00 quoted price shows the label of 250000). If anyone can make a quick suggestion, I would be very appreciative.
