AnsweredAssumed Answered

Help with Function in Calculated Attribute

Question asked by Lowell on Mar 7, 2017
Latest reply on Mar 8, 2017 by Lowell

Hi All,

The list of formulas in the Calculated Attribute Field is very limited.  I need to be able to perform a calculation that does a "count" of values greater than 0.  There is no "Count" function available.

 

Does anyone know how to translate this function into something that works in the Calculated Attribute Field?

 

(IFNULL(sum(cop_scope_status),0)+IFNULL(sum(cop_schedule_status),0)+IFNULL(sum(cop_cost_eft_status),0))/(count(cop_scope_status)+count(cop_schedule_status)+IFNULL(count(cop_cost_eft_status),0))

 

The only functions available are:

Absolute

Add

Average

DateDiff

Divide

Max

Min

Multiply

Percentage

Power

Round

Sqrt

Subtract

Sum

Trunc

Outcomes