2 Replies Latest reply: Aug 6, 2012 10:25 AM by Celambarasan Adhimulam RSS

    min value - max value of field by dimension

    brandon breitling

      Hi community,

       

      How would I do aggr on the following to get the max value - min value for my dimension Project Name?  Here is my code, and what I tried:

       

      max(total DATES_ISO_DATE2)-min(total DATES_ISO_DATE2)

       

      aggr((max(total DATES_ISO_DATE2)-min(total DATES_ISO_DATE2)),[Project Name])