KPI CURRENCY FORMAT

[KevinJ]

Hi 

I cannot format my Amount. Currently it is like this and I want to format it like this:

-2.32 B
-2.32 M

-2.32 K

This is my current script right now. 

sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])

[Digvijay_Singh]

You may do something like this to get the desired results - 

Num(if(sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000000000>1,sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000000000,
if(sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000000>1,sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000000,
if(sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000>1,sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000))),
if(sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000000000>1,'#,##0.0 B',
if(sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000000>1,'#,##0.0 M',
if(sum({$<[Item Type]={'Service'},[PHPCurrency]={'PHP'}>}[Subtotal. Std.])/1000>1,'#,##0.0 K'))))

[Rohan]

Hi Kevin,

You simply need to adjust the numformat varaible in the main section to :

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';

& set your format to Auto in the KPI.

Regards,

Rohan.

[Chanty4u]

Try this

Num(sum({$<[Item Type]={'Service'}, [PHPCurrency]={'PHP'}>}[Subtotal. Std.]), '£#,##0.00 B')