ljungholms

Need help on a calculation

Discussion created by ljungholms on Jul 17, 2017
Latest reply on Jul 17, 2017 by ljungholms

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.

 

So

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.

 

Thanks

Outcomes