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 |
---|---|
36 | |
35 | |
27 | |
23 | |
18 |