When calculating total cost...I need to multiply a duration field by a number to get cost. Is this possible?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I tried the following so far, but getting an error still.

ToNumber(ToHours([Duration]))*[Rate]

However, my duration field is setup as "Formula-Duration" not just "Duration" in terms of field type.

Am I able to take the duration in the field I have setup as "formula-duration" and multiply it by a number to get total cost?

Photo of Amanda

Amanda

  • 0 Points

Posted 3 years ago

  • 0
  • 1
This should work

ToHours([Duration])*[Rate]