AnsweredAssumed Answered

advanced label rounding in 10.2?

Question asked by chrisjcantire on Nov 26, 2015
Latest reply on Nov 27, 2015 by rfairhur24

well, advanced to me anyway....thanks all for giving this a shot:

 

I have big dollar values in my data which will appear in the labels; some will be in the hundreds of thousands, some will be in the millions.  I've been asked to label then with suffixes depending on their amount:

 

$945728.73 should appear as $946M (in the hundreds of thousands)

$1726538.34 should appear as $1.7MM (in the millions)

 

I'm ok with simple vb label rounding, ie. round(value,2), easy, but I'm way out of my depth with this new one, can anyone guide me?

 

thanks!

 

cj

Outcomes