1 Reply Latest reply on May 7, 2018 1:37 PM by Patrick A Van Der Hyde

    A complex calculation - correlation of retention and task done to-date

    Dennis Pong

       

      Here is the calculation for MoneyIn (1)

      Would like to see if I can get help on the following requirement.

       

      basically I wanted to bucket what's originally in week1 & week2 into Week2's calculation. This is my try below. And would like to see if there are any custom table calculations that I do this kind of calculations that requires the cumulative columns, kind of like a running correlation across the table.

       

       

      So is there anyone who's done something similar and know how exactly I should approach this problem ?