Loading

TEXT and ISBLANK report formulas return different results in reports than at the record level

Veröffentlichungsdatum: Oct 13, 2022
Beschreibung

When displaying formula fields with a combination of the TEXT() and ISBLANK() functions on a Date or Date/Time field, there may be inconsistencies between a your report's results and the values displayed on the records themselves.

Examples: 

  • A record will contain a FALSE value, but the report will display TRUE
  • On the record, the value will be blank. On the report, the value will return with "Z" as that is how it is recorded in the database.
Lösung

The workaround is to eliminate the use of the TEXT() function from the formula. The use of ISBLANK(Date/Time) works just fine and will produce consistent results.

Nummer des Knowledge-Artikels

000386828

 
Laden
Salesforce Help | Article