19 Replies Latest reply: Oct 5, 2012 2:45 PM by Brian Garside RSS

    How to Find last value in Table using Bottom function

      Hello,

       

      I'm trying to find a way to return the last valid value in a Straight table Column  BCWP

      in this example  its: 20,770 

       

      Would like to find a clever way to get the value without having to hard code the 6 since its located at this row from bottom.

      Bottom(Sum( EV_TBC * %Complete),6 ,0)   I want to use this in another calculation to return the last cumulative value.

       

       

      Cumulative values in BCWP

      WeeksBCWP
      03-Sep-12$525
      10-Sep-12$2,800
      17-Sep-12$5,885
      24-Sep-12$7,820
      01-Oct-12$9,725
      08-Oct-12$15,170
      15-Oct-12$20,770
      22-Oct-12$0
      29-Oct-12$0
      05-Nov-12$0
      12-Nov-12$0
      19-Nov-12$0