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

[avkeep01]

Hi Pranav,

Try:

=NUM(if(912000>10000000, 912000/10000000, 912000), if(912000>10000000, '###.## Crores', '###.### Lacs'))

probably change 912000000 to the corresponding fieldname of course.

[Mark_Little]

Hi,

Not sure on why you are doing the 912000000>10000000 part as it will always be true, but to display

Make sure you do your division in the the expression. Then Change number fomat to custom and add your form '###.## Crores' in the Format Pattern.

Mark

[Anonymous]

but it would display the wrong value it will simply append crore behind every value,

above expression will check if the value is in lacs or crores, and based on the value check it will remove zeros and displays the value

[teiswamsler]

Hi Pranav

try using the money() funktion insted if num(),

/Teis

[Anonymous]

that doesn't work because i want to divide the value by 1 lac if its less than crore and if its in crore i'll divide the value by 1crore and based on the value check lac/crore tag is appended to the end of value.. i hope know you understand my problem

[Anonymous]

For Lakhs you can use Num(912000000/100000, '###.##')  as Num(912000000/100000,'0.00L')

[Anonymous]

that works for KPIs only and not in barchart..

[Anonymous]

Which dimension and measure are you using in bar chart? Can you please specify.

[Anonymous]

my dimension is ID and in measure i've written this expression:

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