Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..