Number abbreviation for extension visuals

[williamyuen96]

I'm trying to include a extension visuals into my app and I'm aware of the number abbrevation to convert from 'G' to 'B' by using this script :

SET NumericalAbbreviation='3:K;6:M;9:B;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

However, this only works for the normal KPI visual but not does not affect the extension KPI visual. How do I change the format from G to B? Take note that the KPI will require to filter frequently so setting it as B permanently will not work since some figures will go to M depends on what the user is filtering. Thanks !

[ChiragPradhan]

Hi, 

I don't think it is currently possible to do this in an extension. 

You best bet is to do something like this - 

=If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'$#,###B'), Num(sum(Amount)/1000000,'$#,###M'))

 Regards,

Chirag

[williamyuen96]

Great ! it worked ! but how do i edit it if i want to include hundred thousand and thousand too ?