Details about this thread
  • State Not Answered
  • Replies 3 replies
  • Subscribers 321 subscribers
  • Views 243 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?

  • 0

    Hi Millie,

    After trying some workarounds that I thought could have worked but sadly don't, I would recommend changing the field from a currency to a number.

    Unless someone else in Sugar Club has an answer Sweat smile

    Kind regards,

    Nord

  • 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

  • 0

    Hi 

    I have a calculation that provides a currency value as a percentage of another currency field.  It is for the "restock fee" in a return goods authorization .  The rga_restock_percent field is decimal.

    divide(multiply($invoiced_amount_c,$rga_restock_percent_c),100)

    Bud Hartley | Cape Foulwind, NZ (and Oregon, USA)