Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Pranav,
Try:
=NUM(if(912000>10000000, 912000/10000000, 912000), if(912000>10000000, '###.## Crores', '###.### Lacs'))
probably change 912000000 to the corresponding fieldname of course.
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
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
Hi Pranav
try using the money() funktion insted if num(),
/Teis
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
For Lakhs you can use Num(912000000/100000, '###.##') as Num(912000000/100000,'0.00L')
that works for KPIs only and not in barchart..
Which dimension and measure are you using in bar chart? Can you please specify.
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')