Forum Discussion

AlexBartholomew's avatar
AlexBartholomew
Qrew Member
4 years ago

Have some Numeric formula fields and a Duration formula field

What I am trying to accomplish is converting the numeric formula fields to be duration fields. So that I can then multiply the converted numeric field with a duration field. 

[REF Units Remaining] is a numeric formula field
[Normal hrs/weeks] is a numeric formula field 
[# of weeks left on REF] is a duration formula field

I tried setting it up like this: Hours([REF Units Remaining] - (Days([Normal hrs/weeks]) * [# of weeks left on REF]))

The error I'm getting is on the asterisk, saying The operator "*" can't be applied on type of duration, duration

I need the two right fields multiplied together then subtracted by the left field.

------------------------------
Alex Bartholomew
------------------------------

2 Replies

  • You just need to do toWeeks([# of weeks left on REF]) to change it from a Duration to a Numeric type.  

    ------------------------------
    Andrew Nelson
    ------------------------------
    • AlexBartholomew's avatar
      AlexBartholomew
      Qrew Member
      Thank you Andrew. It worked

      ------------------------------
      Alex Bartholomew
      ------------------------------