Filtering data removes everything from report
I have a data set with student grades in a column. When I set a filter for the following commands, all information on the report goes away.
Filter: Final Calculated Grade >is greater than 79
Do I need to format the FCG column in some manner?
Thank you!
Best Answer
-
Does the field contain just a number or a formula. If just a number in a text/number field, it will work. I suspect that you are using a formula and the formula is outputting a text field which will cause it to filter out all information. If that is the case, wrap it in a Value( ) formula and it will convert the text back to a number. If it doesn't work, post a snapshot of the sheet and formula. You could also probably change the formula to output a number instead of text. Use 85, not "85" as an example.
Answers
-
Does the field contain just a number or a formula. If just a number in a text/number field, it will work. I suspect that you are using a formula and the formula is outputting a text field which will cause it to filter out all information. If that is the case, wrap it in a Value( ) formula and it will convert the text back to a number. If it doesn't work, post a snapshot of the sheet and formula. You could also probably change the formula to output a number instead of text. Use 85, not "85" as an example.
-
Thank you, I believe this was my issue. However, I corrected it by reuploading my information and I unchecked the box "input with formulas". Once I did this it worked.
I appreciate your guidance!
