Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to round of using the below one
if the money value is 5678999.23 then it should display as 56.23 lakhs. I am ableto display the y axis value as 50 lakhs by using the propery Money.But still the expression value is showing the entire amount. Is it possible to achive using money.
set the expressions format as well
You can try using expression symbol, thousand symbol etc in Number tab. There is no lakhs symbol though.
You can always try num(<expression>/100000,'0.00 Lakhs')
Regards,
Kiran.
Hi Jollybaba,
Thanks for your response. As of now i am dividing by 100000, Would like to know the same can be achived using the Money function.
try using something like
=money( 23425366/10000, 'Rs #,##0', '.' , ',' )
of course you can replace the 23425366 with <expression>