0

Computed fields vs formula

Folks.. Here is a nifty sample to add to the Project Template..  Computed Percent Complete using:

100 * sum('Sub Project'.Task['Sub Project'.Task.Status = 3].'Sub Project'.Task.'Time Consumption') / 'Time Consumption'

Question.. 'TIme Consumption' is a formula on the Project table.. Is there any difference refering to that formula field vs. writing the sum formula in the above?
pctComplete

2 replies

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    OH.. and another "interesting feature" is that when formatting the number as a %... I still had to multiply it by 100... I would have expected the % format to display a numeric value of 0.1111 as 11.11%.. 

    • Birger_H
    • 5 yrs ago
    • Reported - view

    You are right. The label "%" is just that: A label.

    Birger

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1748Views