Help with a custom row level summary formula

Question

I am trying to pull the duration between the Case Opened Date (CreatedDate) and the Cancellation Date (Account.Cancellation Date) in a custom report. It keeps throwing below error.

The Cancellation date is on the account object and the case details are on th case object. Is that the reason? I have tried all variations, but in vain.

Help with a custom row level summary formula

Regards,

Vinitha

Ahilesh Ragavan Radhakrishnan · Accepted Answer

Thats' right - To convert a date/time field into a date field we can use the DATEVALUE function like this: Account.Cancelled_Date__c - DATEVALUE(CREATED_DATE)

Vinitha Subramanya · Answer

The Account Cancellation date is a Date field whereas the Case Created Date is Date/Time field. Is that the reason?

Help with a custom row level summary formula

Data Management

Related Learning

More Help