You need to sign in to do that
Don't have an account?
Cris9931
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:
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
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...
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