Jump to content

Sum function doubt


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

Recommended Posts

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.

Link to comment
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.

Link to comment
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.

Link to comment
Share on other sites

This topic is 6436 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

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.