1 Reply Latest reply on Sep 18, 2018 11:24 PM by lei.chen.0

    Variance Calc (CM for CY & PY)

    anusha.bint

      Hi - I have a requirement to calculate the variance for the running sum on the current month of current year with a same current month of the prior year. For example this month it is going to be Sep-18 vs Sep-17.

       

      Attaching the excel with the sample data and expected report output.

       

      Data

      Report Output Expected