Cazito Posted June 7, 2004 Share Posted June 7, 2004 Hello ev Link to comment Share on other sites More sharing options...
-Queue- Posted June 8, 2004 Share Posted June 8, 2004 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 More sharing options...
Cazito Posted June 8, 2004 Author Share Posted June 8, 2004 No Queue, I Link to comment Share on other sites More sharing options...
-Queue- Posted June 8, 2004 Share Posted June 8, 2004 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 More sharing options...
Cazito Posted June 9, 2004 Author Share Posted June 9, 2004 Thanks Queue, but I don Link to comment Share on other sites More sharing options...
-Queue- Posted June 9, 2004 Share Posted June 9, 2004 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 More sharing options...
Cazito Posted June 10, 2004 Author Share Posted June 10, 2004 Yeah, I guess you Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7260 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 accountSign in
Already have an account? Sign in here.
Sign In Now