AnsweredAssumed Answered

Summing

Question asked by tays01s on Aug 21, 2017
Latest reply on Aug 22, 2017 by tays01s

I am tryping to 'sum' the numerical values from Activity::Time for each of the different values in Activity::Activity (eg. "Leave"). The summed field is in the related parent field: Date::Leave. The relationship is: (DATE) __uuID = Activity::_Date_uuID.

 

I had thought to make 'Date::Leave' a calc field using the syntax:

Sum(

If(

__uuID = Activity::_Date_uuID and Activity::Activity = "Leave";

Activity::Time;0)

)

However, this fails to present correct data.

Outcomes