How do I add OPS (On-base percentage + Slugging) to an overall report?
NOTE: OPS = OBP + SLG
For an overall report, the following would be put in the Result field (edit report mode, add new field):
(sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate)) + ((sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice))
You also want to make sure the Format is: #0.000