Skip to main content

Hi everyone, 

I have a Joined Report. I want to create a formula to calculate the number of months from the "Create Date" or "Date Installed" field. 

 

Counting days in the Joined Report 

 

Can anyone help me?  Thank you,

 

@Reports & Dashboards

 

 

#Reports & Dashboards

4 answers
  1. Mar 31, 2:56 PM

    Unfortunateky it IS what it IS.  You simply can't have a Row-Level Formula in a Joined Report, there is no magic work-around or backdoor.  

     

    You have to pick 1:  

     

    a Singular Report WITH your Row-Level Formula   

     

    OR  

     

    a Joined Report WITHOUT your Row-Level Formula   

     

    Those are your only options, you can't have both  

     

    otherwise you'll need to create a Custom Formula(Number) field on the Object, or maybe try a Custom Report Type  

     

    #SorryBabyIhadtoCrashThatHonda

     

     

      

     

0/9000