topic Re: Convert numbers in Million or thousands in SAS Visual Analytics

Convert numbers in Million or thousands

abdullahhsafar — Wed, 04 Oct 2023 16:55:31 GMT

i have bar chart shows total amounts month on month and i want to present the numbers in shorter decimals

total numbers without filteration are in million, however if i filter it by specific customer it will be less than million.. dynamic numbers

how i can do this ?

Re: Convert numbers in Million or thousands

Sam_SAS — Wed, 04 Oct 2023 17:05:11 GMT

Hello,

In newer versions of VA, you can use the Abbreviate Numeric Values option (on the Options pane for the bar chart) to get the result that you are looking for.

I believe that the option is enabled by default, so you probably have VA 8.5 or earlier.

Sam

Re: Convert numbers in Million or thousands

AhmedAl_Attar — Wed, 04 Oct 2023 22:02:24 GMT

Hi @abdullahhsafar ,

One other alternative, if you are not at the latest version of SAS Visual Analytics, is creating custom SAS formats and associate it with your data!

Check out this 2014 Blog by @ChrisHemedinger Format your data like a social media superstar

Hope this helps,

Ahmed