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

    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)

Reply
  • 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)

Children
No Data