I have a custom field that captures the Sales Price (currency field) of an item from Salesforce.
I want to take the ACTUAL COST field and divide it by the Sales Price to find what percent of the sales price is actual cost and have it entered in the new custom field I created - Cost of Sales %
The result ends in an error: Error: Data types Currency and String not compatible for '/' operation. Am I doing something wrong? Is there a work around for operations on currency data types?
Please sign in to leave a comment.
Hello Deborah,
Based on the error, it seems that the C_SalesPrice field is a text field in Clarizen. Could you please double check?
If it is actually a currency field in Clarizen, please create a support ticket.
Thank you,
Roland