AnsweredAssumed Answered

Find says 'blank' calculation fields aren't blank.  Any advice or fixes?

Question asked by jeremyb on Oct 14, 2016
Latest reply on Oct 20, 2016 by jeremyb

For 5 seemingly random records (of over a million) I have a Calculation Field that appears blank in Table View and downloads to excel blank but is "found" when search on that field is for "*". Any clue why? The calculation is set to only return different text strings if conditions are met, and the field type is TEXT.  I've only started having this problem this week while database and the calculation field have been around for 1.5 years (though always tinkering with the calculation and the database).  Any help is welcome!

Thanks, Jeremy

Outcomes