How to display data in crores and lacs format in measure of barchart?

[Anonymous]

so this is the condition :

if(912000000>10000000, Num(912000000/10000000, '###.##') & 'Crores', Num(912000000/100000, '###.##') & 'Lacs')

this expression helps me to convert value label from million to crores but its not displaying in barchart

Example (output):

please help

[Anonymous]

Try this instead

if(Sum(Salary*10)>10000000, Num(Sum(Salary*10)/10000000, '###.##') , Num(Sum(Salary*10)/100000, '###.##') )

For me its showing bars properly.

[Anonymous]

but i want that crore and lac tags , thats the main purpose i'm using this expression..

[Anonymous]

Can you try this and let me know,

if(Sum(Salary*10)>10000000, Num(Sum(Salary*10)/10000000, '#,##0.00C') , Num(Sum(Salary*10)/100000, '0.00L') )

[Anonymous]

Yess i tried that also , is it showing that C and L in your output??

[Anonymous]

Yes.

[Anonymous]

it isnt working in my dashboard , maybe because i'm using November 2017 version , can u send me your qvf file please??

thanks for helping..

[Anonymous]

Try formatting->Custom and give this #,##0.00C as format pattern

[Anonymous]

ohh so thats how you are getting C at the end of your value, that's wrong because it will append C at the end of every value be it 8.38 lacs or 8.38 crores. your output is wrong...

[Anonymous]

I have used the expression as measure. I suggested another workaround for crores if you want values to be expressed as crores only.

[Anonymous]

No no it doesn't work that way , u didn't understand the problem ,

some bars in my data shows value in lacs and some bar's value is greater than crore .. so your solution will show all the values in crore.