Filtering data removes everything from report

Arrita

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!

dojones

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.

dojones

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.

Arrita

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!