In my baseball league the game result can be a tie. Is it possible to add a game result as a tie? Then the overall team record can be 5-2-1?

Statbook
2011-06-02 17:30

Yes. Select the report (e.g., Game Results) and check the "Record wTies" field in the Fields list. If you have removed this field, then you will need to edit the report and select "Record" from the field list and then enter in the following for the 'Result' field:

(SELECT SUM(CASE WHEN g2.Result like 'W%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'L%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'T%' THEN 1 ELSE 0 END) FROM Games g2 WHERE g2.GameNo <= g.GameNo)

And then make sure you save the report. You can also simply select 'Record (with Ties) from the Favorites list.

Average rating: 0 (0 Votes)

You cannot comment on this entry