Value convert to Billion/Million etc

[Nagaraju_KCS]

Hi Community,

I have converted values into Billions, but facing issue with restrict selection and negative values.

I did manage with below variables, but negative values (for negative values - couldn't manage with dual function also)

SET vSize = Div(Log10($1),3);
SET vFormatNumber = Dual(Num($1/Pow(10,3*$(vSize($1))),'$ #,##0.0')&' '&Pick($(vSize($1)),'K','Mil','Bil','Tril'),$1);

below are two chart 1st chart showing values working fine

second one converted to billons/Millions, but not working properly (Exclude month and negative values are not working)

Thanks in Advance!

[Nagaraju_KCS]

I did manage with negative values using fabs.

SET vSize = Div(Log10(fabs($1)),3);

anyone can help me on exclude month ? (in set analysis Month= is not working)

any other way work around ?

[Nagaraju_KCS · Accepted solution]

Managed with this ....

dual(num(sum(Value)/pow(10,3*floor(log10(sum(Value))/3)),'$ #,###.#'&pick(floor(log10(sum(Value))/3),' ts', ' mn' , 'bn')),sum(Value))