Post

2 followers Follow
0
Avatar

Custom Field to calculate what % of Sales Price is Actual Cost

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?

Deborah Washburn Answered

Please sign in to leave a comment.

1 comment

0
Avatar

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

Roland Pumputis 0 votes
Comment actions Permalink