My data looks like below, 0 mixed with null. I do not know why because in my excel all my data is filled with number.
Please attach twbx.
In general, the field is recognized as "string" where it should be "numeric value" or vise versa.
So, when you modify the data field type those should be corrected.
Auto-recognition is based on first certain number of rows.
Updated! please check it out!
You don't need to create respective race's calculated field at all.
If you need specific race's value fpr some prupose, you should use
Retrieving data ...