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

    min value - max value of field by dimension

      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])