Change the representation of G to B for Billion figure

[amanjain57]

Hi, How can i change the representation of G to B for a billion figure. Although i know that billion is represented as G, but still users in my organization are used to see it as a B.

Any suggestions??

[#2]

This is kind of cheating, but hey, if it works...

if(Sum(A)>=1000000000 and Sum(A)<=999999999999,round(Sum(A)/1000000000,0.01) & 'B', Sum(A))

[simondachstr]

It's not cheating, it's bad practise.

[#4]

Fair enough. From these links though it seems that Qlik doesn't actually allow to change the number formatting without changing the javascript (which is banned): 173958, 760274 230923, 558909‌, 166582. So even though it's "bad style" (and it really is), I personally don't see a different option. There could be one though.