AnsweredAssumed Answered

Count number of times value occurs in a portal field

Question asked by covita on Sep 8, 2014
Latest reply on Sep 8, 2014 by covita

Thanks in advance for any guidance here...

 

Due to my limited skill set, I have spent roughly four hours trying to do something that seems obvious (but I am stumped):

 

Within a layout based on a Milestones table, I have a portalshowing the related Tasks. (That is working just fine.)

 

In the portal, each Task added to a row (Task record) is assigned a status from a dropdown list (values include On Target, Behind, Completed).

 

I'd like to return a numeric value (to a field in the parent Milestone table) that gives the number of times a task has the "Completed" status value selected.

 

Happily, this challenge has driven me to become more familiar with calculations. Sadly, I have yet to arrive on one that works.

Outcomes