9 Replies Latest reply on Jan 15, 2020 1:58 PM by Bryce Larsen

    % change first vs last?

    David Wilkes

      I need to calculate the % of change of the last value vs the first for each of a specified record set, and order the results.

      1. e.g. I have Name, DateTime, and Rate. For each “Name” I want to see the percent of change for the oldest vs the newest record in order largest to smallest.

      I have been able to use the Table Calculation “Percent Difference From”, Relative to first, to create a table with the data, but I need to limit the results to only the last value (% difference from first).

      table.jpg