Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I would like to create an acumulative field with cost on Set Analysis. I have to aggregate the cost by date and this date is filtered:
months: =DATE(IF(DATE1>=AddMonths(monthstart(today()),-12) and DATE1<= AddMonths(today(),-1), MONTHSTART(DATE1)),'MM-YY')
Cost: =rangesum(above(MT_COUT_SHAM,0, MONTHSTART(DATE1)))
Whith this formulas I can't do it:
Thank you very much
rangesum(above(sum(MT_COUT_SHAM),0,12))
rangesum(above(sum(MT_COUT_SHAM),0,12))