Forum Discussion

AlexBartholomew's avatar
AlexBartholomew
Qrew Member
5 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] ...
Formulas and functions
AndrewNelson's avatar
AndrewNelson
Qrew Cadet
5 years ago
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
    5 years ago
    Thank you Andrew. It worked

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