Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing the symbol from $ to Rs in Money Function

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.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

View solution in original post

4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

   

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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

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

Not applicable
Author

Thanks all. Baeyens answer well fits mine.