1 2 Previous Next 21 Replies Latest reply on Sep 8, 2014 4:54 PM by covita

    Count number of times value occurs in a portal field

    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.

        1 2 Previous Next