Changing the symbol from $ to Rs in Money Function

[#1]

Hi All,

How to set the Symbol as "Rs" instead of "$" in the result of this expression "='Average Line Total = '&Money(Avg(LineTotal))"?

Thanks in advance.

[kaushiknsolanki]

Hi,

    Go to properties of chart -> Number -> Click on money -> Look for format pattern type,

    Rs:#,##0;-Rs:#,##0

    Hope this will help you.

Regards,

Kaushik Solanki

[#3]

Hi,

Not sure i have understood your Question. You want to change the money formate from $ to Rs. is it?

You could do it from Number table by changing the $ sign to Rs. or you could it with expression also using Num() function.

Have a look at the attached application.

- Sridhar

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

All the above will work but you will have to change for every expression. If you want to do the change document wise, go to the script editor, main tab, and change the following line

SET MoneyFormat='$#,##0.00;($#,##0.00)'; // Or the values you have from your Operating System locale configuration

to

SET MoneyFormat='Rs#,##0.00;(Rs#,##0.00)'; 

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#5]

Thanks all. Baeyens answer well fits mine.