function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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:  But i'm still lost...

Zachary SingerZachary Singer
Hi Cris9931,
Please check out these discussions, you may need to rewrite the formula