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.

Knowledge 기사 번호

000386828

 
로드 중
Salesforce Help | Article