4 Replies Latest reply: Apr 28, 2017 7:40 AM by Sunny Talwar RSS

    Roll up to 1st date

    Aishwarya R

      Hi,

         

      DateCol ACol BCol CMTD
      01-01-2017522125%
      02-01-201735473%

      03-01-2017

       

      442

      85%

       

       

       

      In the above table the MTD column logic for 01-01-2017 is : Col A /( Col B + Col C) i.e 5 / (2+2)

      Logic for 02-01-2017 is : sum(Col A) / (sum(Col B) + Col C)  i.e (5+3) / ( (2+5) + 4)  and this roll up continues for the rest of the dates. Also the roll up should be restricted to the 1st of every month.

      Can someone please tell me the set analysis to achieve the same in the front end?