However, when I create a field history report and try to filter by New Value greater than 1000, it seems to read the scores as a string, and returns everything that is later "alphabetically" than 1000, which is basically everything (it returns 105 and -225, for example). How can I achieve what I'm looking for?
2 respuestas
Field History Reports are VERY limited, all of the Historical Values are stored as Text (no matter what the Field Datatype is)
Your best bet would proabably be to export the report to Excal and reformat the data there
