Explore - Custom Text Field returning NULL in Standard Calculated Attribute | Community
Skip to main content

Explore - Custom Text Field returning NULL in Standard Calculated Attribute

  • January 22, 2023
  • 1 reply
  • 0 views

Matthew32

I am seeing that my standard calculated attributes are showing up as null. Zendesk support said this to me:

 

"At this time, unfortunately what you are experiencing is expected."

 

Below is the formula that shows up as null for many, but not all tickets:

IF ( 
[Updater role]="End-user"
AND [Comment present]=TRUE
AND [Comment public]=TRUE 
AND DATE_LAST_FIX([Update - Timestamp],[Comment present],[Comment public],[Updater name],[Updater role])=[Update - Timestamp])
THEN [Update - Timestamp]ENDIF

1 reply

Amie11
  • January 23, 2023

Hey @matthew32

What is your actual feature request here? Is it for the result to display 0 (or something else) instead of NULL?