7 Replies Latest reply on May 29, 2018 10:24 AM by Meghan Kyle

    Return a value for Min Date in View

    Meghan Kyle

      Hi,

       

      I want to create a calculated field that returns the value for the min date in view.  I want to then use this field in other custom calculations that have been requested by the business. 

       

      Example:

       

      Balance
      FY16Q158,000
      FY16Q220,000
      FY16Q370,000
      FY16Q45,000
      FY17Q112,000

       

      How do I create a calculated field that will figure out 58,000 is the value I want?

       

      Goal - Calculated Field:

       

      DimensionCalculated Field
      FY16Q158,00058,000
      FY16Q220,00058,000
      FY16Q370,00058,000
      FY16Q45,00058,000
      FY17Q112,00058,000

       

      Thanks!