0 Replies Latest reply: Aug 1, 2011 11:52 PM by Nick Gan RSS

    set analysis with date

    Nick Gan

      Hi,

       

      I'm trying to implement a date range of last 12 month into the following formula.

      can someone helps?

       

      count({$<NUM_SUPPLIER.SUPPLIER_GROUP_CODE=, NUM_SUPPLIER.SUPPLIER_GROUP_DESC=, ZONE=>} distinct aggr(if(sum({$<NUM_SUPPLIER.SUPPLIER_GROUP_CODE=, NUM_SUPPLIER.SUPPLIER_GROUP_DESC=, ZONE=>}  NUM_SUPPLIER.Spend_Turnover)<>'0',NUM_SUPPLIER.SUPPLIER_CODE),NUM_SUPPLIER.SUPPLIER_CODE, RollingTwelveMonthsAsOfMonthYear))