Format number in Chart Title based on Calculation
I want to format a number (Summary field) that is part of a chart title created with a calculation as shown on the attached screenshot.
The calculation for this Chart Title is shown below. The field name is highlighted in red.
"Annual Contract Value: " & If
ValueCount(TO_name::_Edition) = 1;
Upper(TO_name::g_Edition & " " & TO_name::SummaryField);
"ALL EDITIONS"&" " & TO_name::SummaryField
Is there a way to format this Summary field as Currency or at least with thousands separator?