5 Replies Latest reply on Nov 27, 2018 11:35 PM by Nicole Cheong

    MIN and MAX - not displaying correct results

    Nicole Cheong

      Hi there....

       

      Am trying to calculate the MIN and MAX values of the Tranche # based on a set of data sources. As you can see from the screenshot, the 1st initiative is the one with an issue while it is displaying the right result for the 2nd initiative. For the 1st, the MIN is 10 and MAX is 8. Seems like it is swapped. I have use a calculated field to do this and am puzzled as to how the results can differ if the same formula is applied across the board.

       

      Anyone can assist? Much appreciated.

       

      Formula for MIN:

      {FIXED [Initiative Title]: MIN (if [Data Sources and/or Consumers]= "I" then [Planned Ingestion Tranche # as of Oct 2018] end)}

       

      Formula for MAX:

      {FIXED [Initiative Title]: MAX (if [Data Sources and/or Consumers]= "I" then [Planned Ingestion Tranche # as of Oct 2018] end)}