7 Replies Latest reply on Jul 25, 2018 3:02 AM by Daniel Higgins

    1% Growth Calculation

    Tom Bryson

      I'm trying to create a calculated field that will look at a row of data 2018 - 2028 and will apply a 1% increase year on year (apply a 1% increase to the previous number in the calculation) and show this as another line on the chart. (header 3)

       

      Does anyone know what the calculation would be?

       

      Example

      Header 1Header 2Header 3
      Year Number of StaffNumber of Staff +1%
      2018

      100

      101
      2019

      100

      102
      2020100103
      2021100104
      2022100105
      2023100106
      2024100107
      2025100108
      2026100109
      2027100110
      2028100111