Money

[#1]

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.

[#2]

set the expressions format as well

[#3]

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.

[#4]

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.

[#5]

try using something like

=money( 23425366/10000, 'Rs #,##0', '.' , ',' )

[#6]

of course you can replace the 23425366 with <expression>