AnsweredAssumed Answered

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

Question asked by ODRA2006 on Nov 10, 2015
Latest reply on Nov 11, 2015 by okramis

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!

Outcomes