+ Start a Discussion
Cris9931Cris9931 

Formula field displaying #Error

Hi, I have a formula field which displays correct value on the record but when I put in a Report or List view it displays #Error.
 

This is the formula field:
 
FLOOR((DATETIMEVALUE(TEXT(SVMX_PS_Customer_End_Date__c )&" "& TEXT(SVMX_PS_Customer_End_Time__c ))-
DATETIMEVALUE(TEXT(SVMX_PS_Customer_Start_Date__c )&" "& TEXT(SVMX_PS_Customer_Start_Time__c )))*24)

 

Basically it substracts End Date+ End Time - Start Date + Start Time and display it in hours

User-added image

Can someone make me understand why I see #Error on list view+ report but in record I see the value. I already checked a documentation from Salesforce: https://help.salesforce.com/s/articleView?id=000331331&language=en_US&type=1  But i'm still lost...

Zachary SingerZachary Singer
Hi Cris9931,
Please check out these discussions, you may need to rewrite the formula
https://developer.salesforce.com/forums/?id=906F00000008xCaIAI
https://developer.salesforce.com/forums/?id=906F00000008oEGIAY
https://help.salesforce.com/s/articleView?id=000331331&type=1