0 Replies Latest reply: Jun 18, 2013 4:46 AM by Managing Director. Syfur Rahaman RSS

    set expression didn't work

      Hi,

      below expression works fine.

       

      1.

      =FirstSortedValue($(v_INV_TRX_DATE), -(aggr(max({<TRX_DATE ={'<=$(vSelectedDate)'}>}MAX_TRX), $(vWarehouse),$(v_PRODUCT_CODE), $(vItem),$(v_TRX_DATE))))

       

      but when I used it in blow way then it doesn't work -

       

      2.

      =$(=FirstSortedValue($(v_INV_TRX_DATE), -(aggr(max({<TRX_DATE ={'<=$(vSelectedDate)'}>}MAX_TRX), $(vWarehouse),$(v_PRODUCT_CODE), $(vItem),$(v_TRX_DATE)))))

       

      it returns fixed highest value in all row like 20130531.

       

       

      i want to use number 2 option in set analysis below way and its first greater portion doesn't work - 

       

      =sum({<SR_SALES_TRX_FRMT_DAY={">$(=FirstSortedValue($(v_INV_TRX_DATE), -(aggr(max({<$(v_TRX_DATE)={'<=$(vSelectedDate)'}>}$(v_MAX_TRX)), $(vWarehouse),$(v_PRODUCT_CODE), $(vItem),$(v_TRX_DATE)))))<=$(vSelectedDateNew)"}>}SALES_ORD_INV_QTY)

       

       

      Could please help me regarding this.

       

      thanks in advance