SQRT
SQRT(number)
The square root of a number, such as a step in a standard deviation of task durations. The square root of a negative number is an error on that row, and a duration has to be counted in days or hours first with INDAYS or INHOURS.
Arguments
| Argument | What to give it |
|---|---|
| number | A number, zero or more. A blank gives a blank. |
Examples
Formula=SQRT(INDAYS([Duration]))
The square root of the task's duration in working days.
Measure (on the project)=SQRT(AVERAGE((Tasks[Duration] / 1d - AVERAGE(Tasks[Duration] / 1d)) ^ 2))
As a measure: how widely task durations spread around their average, in working days (their standard deviation).
Reach for something else when
| You want | Use |
|---|---|
| Any other power or root | the ^ operator: INDAYS([Duration]) ^ (1 / 3) |
| The size of a number whatever its sign | ABS |
Common questions
What does "SQRT needs numbers" mean?
The value is a duration. Count it first: SQRT(INDAYS([Duration])), or divide it by a day, SQRT([Duration] / 1d).
=SQRT([Duration])