Loading

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

Дата публикации: Oct 13, 2022
Описание

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.
Решение

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.

Номер статьи базы знаний

000386828

 
Загрузка
Salesforce Help | Article