AnsweredAssumed Answered

Format number in Chart Title based on Calculation

Question asked by sccardais on Mar 29, 2015
Latest reply on Mar 29, 2015 by sccardais

Title

Format number in Chart Title based on Calculation

Post

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?

Concatenated_Chart_Title_.png

Outcomes