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.
Solved! Go to Solution.
It was type Number. I changed it to type Text and it is working now. Thank you very much for your help.
The Grade column must be type Text or Enum with a base type of Text.
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.
What is the Grade column type in the table referenced by Student ID?
It was type Number. I changed it to type Text and it is working now. Thank you very much for your help.
For those that dont know NaN = “Not a Number”
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |