Skip to main content
Question

Have some Numeric formula fields and a Duration formula field

  • February 24, 2021
  • 0 replies
  • 34 views
AlexBartholomew
Forum|alt.badge.img+4
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
------------------------------
This topic has been closed for replies.

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

------------------------------
Andrew Nelson
------------------------------
Terms & ConditionsAccessibility statement