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

    Nested Calculations




      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