2 Replies Latest reply on Jun 27, 2018 8:51 AM by Wesley Magee

    Calculate the difference between this year and last year without a table calculation or parameter

    Greg Useem

      I am trying to develop some dynamic text so that as data gets uploaded the text will automatically update.  I have been successful at creating this function for information about the current year.  But what I want to do is add a sentence that says something like: The number of widgets produced last year was 1,000 and this year was 1,500 and the difference is 500.  I would like to do this without a table calculation or with input from a parameter as I would like the data to update automatically.  The table I am using is simple, and looks like the below.  Thoughts?

       

      YearIndicatorValue
      2018Number of widgets1500
      2017Number of widgets1000
      2016Number of widgets500