How the number format conversion will automatically changes from Mn\Bn....?

[#1]

Hi All,

In my current dashboard i want to display the sum(revenue) figure.In such case based on the number count it should automatically change the number format text from Million/Billion .

The current expression used for that: text(money(Sum(dollar_value_sold)/1000000000)&'Mn')

Regards,

Venugopal G

[swuehl · Accepted solution]

Not quite sure if I got your request right, maybe like this?

dynamically changing scale in text box

[#3]

Hi Swuehl,

Thanks for your reply.....

Awesome it is working fine for me..Need small change in Expression if possible

I want to display the number as separate text object and Bn\Mn conversion as separate text.If you provide the expression that will be great help.

Above image for your reference.

Regards,

Venugopal G

[swuehl]

If you look at this expression sample for example:

=num( sum( revenue) /pow(1000,floor(log10(fabs(sum(revenue)))/3)),'##0.000')

& pick(floor(log10(fabs(sum(revenue)))/3)+1,'',' thousand',' million',' billion',' trillion')

you can easily split it into two parts / text box expressions:

=num( sum( revenue) /pow(1000,floor(log10(fabs(sum(revenue)))/3)),'##0.000')

= pick(floor(log10(fabs(sum(revenue)))/3)+1,'',' thousand',' million',' billion',' trillion')

[MK9885]

I've been trying to do same thing in Qlikmaps, represent the number in M but this seems not to work. any idea or is this only valid for Straight Table?