3 Replies Latest reply on Nov 22, 2018 4:13 PM by David Atwell

    Calculated field with lower level detail

    David Atwell

      I am seeking to create a calculated field using the following data set:


      Jan-12LowerStart of Month220
      Jan-12LowerEnd of Month230
      Jan-12MainStart of Month5524
      Jan-12MainEnd of Month5556


      The calculated fields I am trying to get is:

      The difference between Jan 12 End of Month (Main) and Jan 12 End of Month (Main).


      My expected result should be: 32


      Note: my dataset would have several months data so would expect to have to include in the formula the latest month.


      Any help would be appreciated.