Loading

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

Publiceringsdatum: Oct 13, 2022
Beskrivning

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ösning

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.

Knowledge-artikelnummer

000386828

 
Laddar
Salesforce Help | Article