can we change sorting rule based on expression?

[Anonymous]

hello community,

i have this doubt in my app

i created a bar chart in which i used below expression as measure:

if(Sum(Persons)>10000000, Num(Sum(Persons)/10000000, '###.##Cr'),

Num(Sum(Persons)/100000, '###.##Lacs'))

this expression checks the value and if its greater than 1cr is appends cr after the value else it appends lacs.

after using this i'm getting following output:

so the problem here is it shows 35.86lacs value bar larger than 4.39cr so is there any way i can impose some rule where it will treat lacs value smaller than crore value..

please help..

[mdmukramali]

Hi Pranav,

I have followed marcowedel post to achieve it.

kindly find the attached sample app.

'K','Mil','Bil','Tril') are available in that application.

I think you can change to Lac & Cr

[Anonymous]

sir can you send me the link of that exact discussion where i can find the solution of the matter..

thanks

[pradosh_thakur]

May be this

if(Sum(Persons)>10000000,alt( text(Num(Sum(Persons)/10000000, '###.##Cr'))  ,

Num(Sum(Persons)/10000000, '###.##')

),

alt(text(Num(Sum(Persons)/100000, '###.##Lacs')  ),

Num(Sum(Persons)/10000000, '###.##')

  )

use this expression and may be if required use measure expression in the number formatting instead of auto.

[mdmukramali]

Hi,

Number formatting - millions to billions

check Marco Wedel @marcowedel‌ Reply in that post.

Thanks,

Mukram

[Anonymous]

this way it shows value as 0.36 (i.e) in crores only and it doesnt even append cr at the end

[pradosh_thakur]

hi Pranav

that's why asked you to use measure expression in the formatting.

[Anonymous]

see this its not happening

[pradosh_thakur]

what about this

if(Sum(Persons)>10000000,dual( text(Num(Sum(Persons)/10000000, '###.##Cr'))  ,

Num(Sum(Persons)/10000000, '###.##')

),

dual(text(Num(Sum(Persons)/100000, '###.##Lacs')  ),

Num(Sum(Persons)/10000000, '###.##')

  )

[pradosh_thakur]

I have tried with dual and its working in my app.