How can I format data to be in a money format? The output of a chart is $s.

Posted by Bob Jeffcott

Posted on Thu, 09/22/2011 - 23:01 in MashZone

Instead of 1,124.22, they want the format to be $1,124.22.

Is there an easy way to format data in anything other than numeric or text?

23.8k

by Stephan Freudl

Posted on Wed, 09/28/2011 - 11:06

Hi Bob,

unfortunately the number format does not support constant string prefixes, e.g. "$" in formats.

Regards

Stephan

by Mirko Lindner

Posted on Thu, 10/06/2011 - 10:48

You can create an user-defined tooltip containing special characters (e.g. $).

by Bob Jeffcott Author

Posted on Thu, 10/06/2011 - 18:25

Mirko,

I have looked through the documentation and see where you add the tooltip, but cannot figure out how I might add the special character. How might one do that?

by Stephan Freudl

Posted on Fri, 10/07/2011 - 15:35

That's accomplished in data assignment mode as depicted below.

The tooltip may consist of multiple substrings each formated on an individual basis. Linebreaks as well as category names and KPI values are available via combo box.

How can I format data to be in a money format? The output of a chart is $s.

Featured achievement

Leaderboard

Follow us

View posts by tag