Loading

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

Julkaisupäivä: Oct 13, 2022
Kuvaus

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.
Ratkaisu

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-artikkelin numero

000386828

 
Ladataan
Salesforce Help | Article