function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JaanuJaanu 

Unable to find custom object fields in formula fields while creating the report?

I have created a report from two custom ojects. I have added all the required fields to the report. Now I need to find the difference in two date fields. So, I clicked on the formula, but unable to find these fields to calculate the difference in two dates. Not sure why ? Both these fields are on this report. Still I can't find both these fields while adding the formula. Any reason for this please ? I just need to calculate the working days between these 2 dates - D1 and D2. Please let me know.
Raj VakatiRaj Vakati
Looks like the field is missing from the Report Type  Field Layout Properties.

Go to Report Type >> Select Report Type >> Fields Available for Reports >> Edit Layout >> Drag and Drop Field to Field Layout Properties.

https://success.salesforce.com/answers?id=9063A0000019aEfQAI
https://help.salesforce.com/articleView?id=reports_report_type_layouts.htm&type=5