Throws Error "Syntax Error."

Object :- Opportunity Line Item

Field1 :- UnitPrice Currency(16, 2)

Field2 :- Cost_Price__c Currency(16, 2)

Field3 :- Discount Percent(3, 2)

Field4 :- Gross_Profit__c Formula (Currency) 2 decimal Places

Formula want to Implement is :- UnitPrice - Cost_Price__c – (unit price * discount)

Please Help me to solve this. Thanks.

  • Okay, but did you actually try so far?
    – sfdcfox
    Mar 16, 2018 at 6:41
  • i had tried to convert value(discount) so that it converts in to Number. as well as i tried to change the Formula's return type as "number" with 2 decimal places. But same error Mar 16, 2018 at 6:42

1 Answer 1


It looks like you put a space where one didn't belong:

UnitPrice - Cost_Price__c – (UnitPrice * Discount)

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.