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!

Find more posts tagged with

Reports

Filters

Accepted answers

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.

All comments

dojones

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.