New Bug Encountered: Reference Error?

references
(Kevin Chan) #1

Hello,

My column STUDENT[Grade] won’t reference the text value but it references the numeric value. In column STUDENT[Grade], it has grade 1-12, PK, and K. My reference column has app formula of [Student ID].[Grade], and it managed to reference all grade 1-12 but not “PK” and “K”. It shows “NaN” for grade “PK” and “K”. Please advise. Thank you.

(Steve Coile) #2

The Grade column must be type Text or Enum with a base type of Text.

#3

For those that dont know NaN = “Not a Number”

1 Like
(Kevin Chan) #4

@Steve

The Grade column is set to type Text and I can’t use Enum because the grade is based on selected [Student ID]. Please advise. Thank you.

(Steve Coile) #5

What is the Grade column type in the table referenced by Student ID?

(Kevin Chan) #6

@Steve

It was type Number. I changed it to type Text and it is working now. Thank you very much for your help.

1 Like