1 Reply Latest reply: Dec 1, 2015 10:57 AM by Miguel Braga RSS

    SET Help

    Mayuri Nandu

      Hi,

       

      =SUM(AGGR(if(VYEAR = $(PreviousYear),(BEGIN_BALANCE_DR - BEGIN_BALANCE_CR) - (-(PERIOD_NET_DR - PERIOD_NET_CR))),CODE_COMBINATION))

       

       

      i want to write above expression in set.. as i am coding this for YTD.. is that correct..

       

       

      What will be for MTD, QTD & Half Yearly.. i need for Previous Month & Previous Year MTD also..