# Sum function doubt

This topic is 6642 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

Hello ev

##### Share on other sites

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.

No Queue, I

##### Share on other sites

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.

##### Share on other sites

Thanks Queue, but I don

##### Share on other sites

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.

##### Share on other sites

Yeah, I guess you

##### Share on other sites

This topic is 6642 days old. Please don't post here. Open a new topic instead.

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account