I was bored one day and decided to set up a database to manage a footy tipping comp. In one table I have a field for the HomeTeam and another for AwayTeam. When a user is entering their tip, they have the option of choosing the home team, away team or a draw. I've set up a repeating calculation to store these options in a single field as follows...
Let ( R = Get ( CalculationRepetitionNumber ) ; Choose ( R - 1 ; HomeTeam ; AwayTeam ; "Draw" ) )
It populates the first and third repetitions, but leaves the second empty, even though the AwayTeam field has a value in it. Out of pure desperation, I tried replacing AwayTeam with "test" and it worked just fine. I don't understand why it's not working with the field reference in there, especially when the first one is working. Can anyone alleviate my frustration before I rip out what's left of my hair?