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.