AnsweredAssumed Answered

Repeating calculation frustration

Question asked by lycanthrope7 on Feb 28, 2018
Latest reply on Feb 28, 2018 by user19752

Hi all,

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?

Outcomes