1 Reply Latest reply on Jun 17, 2013 8:26 AM by philmodjunk

    Graphically show difference between two fields over a period of time

    FlorianWiegand

      Title

      Graphically show difference between two fields over a period of time

      Post

           Hello,

           i have a table which reports on the amount of tape libraries beeing used per month.

           Fields: Library_Name ; Scratch ; Month

           Data   : Lib1                   ; 34          ; June

                        Lib1                    ; 36          ;July

           I would a calculation field which shows me that currently there was a growth by +2 from last month. I somehow cant get my head around the calculation.

           Thank you

        • 1. Re: Graphically show difference between two fields over a period of time
          philmodjunk

               IF you had a number field for the number of the month rather than the name it would be easier to sort you records by month to make sure that they are in the correct order, but as long as you have your records in chronological order here, GetNthRecord can access teh value of "scratch" from the preceding record so that you can set up a calcultion that computes the difference between the two records for this field.

               If ( Get ( RecordNumber ) = 1 ; 0 ; Scatch - GetNthRecord ( Scratch ; Get ( RecordNumber ) - 1 ) )