I am looking to create a series of calculations using IF statements. I have 2 field in my related table. Round # and Pass/Fail.
I need to calculate the pass rate as a percentage for RD1, RD2 etc.
if round 1, summary of field/total round 1 records
if round 2, summary of field/total round 2 records
Kind of stuck on this one.