Case Confusion

[Paul Hunt]

How can the following calculation ever result in a null field? The results I get are 1, 2, or empty. Why not 1, 2, or 53? 

Case (Week[1] = 1; 1; Week[2] = 1; 2; 53)

Thanks, Paul

[Ocean West]

Are you using repeating field?

[comment]

22 minutes ago, Paul Hunt said:

How can the following calculation ever result in a null field?

This is how:

[Paul Hunt]

Ah, of course. I should have seen that. Thank you.