6 Replies Latest reply on Aug 14, 2018 6:32 AM by madhuri.tanniru

    Nested Calculations

    madhuri.tanniru

      Hi,

       

      I am trying to mimic calculations I got from an excel workbook. Please find the attached workbook where i have the calculations

       

      The calculations are self referencing the same column, tried to reproduce the same using PREVIOUS_VALUE but couldn't

       

      Calculations are in sheet [3. Get the avg of months_yr] in the column K

       

      I should be able to get the values by Month [Cells K3 thru K12 ]and then by year [Cell K13]

       

      Appreciate any help here

       

      Thanks,