Sum function doubt

[Cazito]

Hello ev

[-Queue-]

You can't use the If within Sum. Sum is a function whose parameters are combined to yield the result. So they need to either be field names or numbers.

I think you want to do it like

If( Sum(Game::GS) > Sum(Game::GA); 1; 0 ), which can be simplified as Sum(Game::GS) > Sum(Game::GA). Note that this will take a long time to calculate for a large number of related records.

[Cazito]

No Queue, I

[-Queue-]

You need calculation fields for each possibility in the Game db.

field: calc

fWin: GS > GA

fLos: GS < GA

fTie: GS = GA

assuming GS is 'our' score.

Then you need three calculation fields in the Coach db.

sWin: Sum( Game::fWin )

sLos: Sum( Game::fLos )

sTie: Sum( Game::fTie )

where 'Game' is a relationship to the Game db based on the coach's id.

[Cazito]

Thanks Queue, but I don

[-Queue-]

You can script it, but you'll still need the first three fields to flag whether each record is a win, loss, or tie. Then you can script Set Field [Wins, Sum( Game::fWin )] and do away with the sum calc fields.

[Cazito]

Yeah, I guess you