Hi Guys, I am working on a tournament management system which I have developed as a desktop database, but now I am working on the web based side of things.
I cannot reference the existing calc fields I have previously added. These calc fields are for use in my grid.
I have 2 formulas that work out which player has won or lost a match. (G1Q1M1W and G15Q4M1W).
Depending which of the 2 fields were True or False, I then use a 3rd calc field that displays the winning players name. (WinnerM1)
This all works fine in the desktop side of things, but maybe it is not possible to use calc fields based on other calc fields in a grid ?
G1Q1M1W = if(Round1->M1G1Q1S1>Round1->M1G15Q4S1.and.Round1->M1G1Q1S2>Round1->M1G15Q4S2.or.Round1->M1G1Q1S1>Round1->M1G15Q4S1.and.Round1->M1G1Q1S2<Round1->M1G15Q4S2.and.Round1->M1G1Q1S3>Round1->M1G15Q4S3.or.Round1->M1G1Q1S1<Round1->M1G15Q4S1.and.Round1->M1G1Q1S2>Round1->M1G15Q4S2.and.Round1->M1G1Q1S3>Round1->M1G15Q4S3,.T.,.F.)
G15Q4M1W = if(Round1->M1G15Q4S1>Round1->M1G1Q1S1.and.Round1->M1G15Q4S2>Round1->M1G1Q1S2.or.Round1->M1G15Q4S1>Round1->M1G1Q1S1.and.Round1->M1G15Q4S2<Round1->M1G1Q1S2.and.Round1->M1G15Q4S3>Round1->M1G1Q1S3.or.Round1->M1G15Q4S1<Round1->M1G1Q1S1.and.Round1->M1G15Q4S2>Round1->M1G1Q1S2.and.Round1->M1G15Q4S3>Round1->M1G1Q1S3,.T.,.F.)
WinnerM1 = if(calc->G1q1m1w=.T.,G1q1,if(calc->G15q4m1w=.T.,G15q4,''))
Thank you
I cannot reference the existing calc fields I have previously added. These calc fields are for use in my grid.
I have 2 formulas that work out which player has won or lost a match. (G1Q1M1W and G15Q4M1W).
Depending which of the 2 fields were True or False, I then use a 3rd calc field that displays the winning players name. (WinnerM1)
This all works fine in the desktop side of things, but maybe it is not possible to use calc fields based on other calc fields in a grid ?
G1Q1M1W = if(Round1->M1G1Q1S1>Round1->M1G15Q4S1.and.Round1->M1G1Q1S2>Round1->M1G15Q4S2.or.Round1->M1G1Q1S1>Round1->M1G15Q4S1.and.Round1->M1G1Q1S2<Round1->M1G15Q4S2.and.Round1->M1G1Q1S3>Round1->M1G15Q4S3.or.Round1->M1G1Q1S1<Round1->M1G15Q4S1.and.Round1->M1G1Q1S2>Round1->M1G15Q4S2.and.Round1->M1G1Q1S3>Round1->M1G15Q4S3,.T.,.F.)
G15Q4M1W = if(Round1->M1G15Q4S1>Round1->M1G1Q1S1.and.Round1->M1G15Q4S2>Round1->M1G1Q1S2.or.Round1->M1G15Q4S1>Round1->M1G1Q1S1.and.Round1->M1G15Q4S2<Round1->M1G1Q1S2.and.Round1->M1G15Q4S3>Round1->M1G1Q1S3.or.Round1->M1G15Q4S1<Round1->M1G1Q1S1.and.Round1->M1G15Q4S2>Round1->M1G1Q1S2.and.Round1->M1G15Q4S3>Round1->M1G1Q1S3,.T.,.F.)
WinnerM1 = if(calc->G1q1m1w=.T.,G1q1,if(calc->G15q4m1w=.T.,G15q4,''))
Thank you
Comment