4 Replies Latest reply on Nov 11, 2015 1:38 PM by okramis

    How can I calculate a sum for a found set based on a related field's first letter

    ODRA2006

      Hey all! I can't seem to nail this... I want the calculation to look thru the found set of records only looking at the first letter of a particular field and summing the "Used" field of all the records with that letter.

       

      Something along the way of: Sum the "Used" field of all the records in which the "Roll #" field starts with "A"

      Screen Shot 2015-11-10 at 5.59.23 PM.png

       

      Please help!