SAP Crystal Report - How to override default formating for number and currency field in formula

0
votes

I am using tonumber function but its adding default formatting and i don't want that mainly thousand separator. Also, for currency, I don't want currency symbol. As I am using these fields in formula field, I cannot set properties, right?

1
crystal-reportssap
post how are you are getting and how want it to be.. A sample data will be helpful... how can we assume things – Siva

1 Answers

0
votes

To remove the thousand separator, I generally do something like

Replace(ToText(YourField),',','')

To remove currency symbols do the same

Replace(ToText(YourField),'£','')