0

I am trying to upload the data using workbench.

The file contains columns as Id, currencyField.

Here is the sample:
ID Column1 | CurrencyField Column 2
XXXXXXX | 1234.33
YYYYYYY | -5678.99

After I load(update) the data into salesforce, I am seeing the currency field as below :
Record1 -> CurrencyField__c = 1234.33
Record2 -> CurrencyField__c = (5678.99)

FYI.. I also changed the formate of that CurrencyField column as below : enter image description here



Please help on how can I load negative currency values and stores in salesforce without "()". I mean, Record2 -> CurrencyField__c = -5678.99

I appreciate your help :)

  • 1
    This is a standard US currency formatting for negative amounts. It's stored as -5678.99 in the database – o-lexi Nov 10 '17 at 1:07
  • Thanks Oleksiy, Yes it stores as -5678.99 in database. But I want to show -5678.99 on Record datail page as well as in reports. So that it will appear to be user friendly. – Naresh Nov 10 '17 at 1:25
  • The easiest would be to convert a Field type to Number – o-lexi Nov 10 '17 at 18:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.