umm .. this does not address drilldown to smaller aggregations that divide by 1,000 would be more appropriate. ... View more

Thanks! I need the Million formatted, firstly, in a CrossTab Report, then a graph would follow based on the data from CrossTab ... View more

The closest format is BESTw.   Could SAS create something like BESTRw. (aka BEST Roman)   Value  >  BEST6.  > * (BESTR4.) 1,234   > 1.23 E3 > 1.23 K 1,234,567   > 1.23 E6 > 1.23 M 1,234,567,890   > 1.23 E9 > 1.23 B 1,234,567,890,123   > 1.23 E12 > 1.23 T ... View more

ok,.. my findings Option 1: Select and activate the Chart, then Right-side Bar> Data Role to move Data Item to Columns; Option 2: New Data Item > Calculated item > text: Does Not understand SAS code 😞 ... View more

Variable SUM_AMT=1,234,567,890 and want VA report to display formatted SUM_AMT value as 1,234.46   ... View more