Details about this thread
  • State Not Answered
  • Replies 3 replies
  • Subscribers 321 subscribers
  • Views 350 views
  • Users 0 members are here

Multiplying a currency field - Calculated fields

Millie White

Hi all,

I have a field where I want it to give me either 80% or 20% of another calculated fields value. 

I went for the easy route of:

multiply($ut_contract_value_c,0.2)

But I get an error message saying the field needs to be a number and it's currency. 

I tried subtract, but that just takes off 20 pence instead of 20%.

Any ideas how I can do this easily without having to edit the original calculated field to use for this one?

Parents
  • 0

    Hi  ,

    We use currency fields in calculations similar to this for our clients, so I need some additional detail on the issue you are experiencing:

    • Is the error encountered when trying to save the formula in Studio or somewhere else in the app? Please provide the exact text of the error received.
    • Am I correct in understanding that ut_contract_value_c is a currency field?
    • What is the field type of the new field you are attempting to create the formula in?
    • You mention that you want the field to give an 80% or 20% value. Does that mean you are using an ifElse formula to determine which percentage to calculate? If so, please provide the full formula you are using in the field.

    Thanks!

    Chris

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

Reply
  • 0

    Hi  ,

    We use currency fields in calculations similar to this for our clients, so I need some additional detail on the issue you are experiencing:

    • Is the error encountered when trying to save the formula in Studio or somewhere else in the app? Please provide the exact text of the error received.
    • Am I correct in understanding that ut_contract_value_c is a currency field?
    • What is the field type of the new field you are attempting to create the formula in?
    • You mention that you want the field to give an 80% or 20% value. Does that mean you are using an ifElse formula to determine which percentage to calculate? If so, please provide the full formula you are using in the field.

    Thanks!

    Chris

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

Children
No Data