0 Replies Latest reply on Oct 14, 2018 10:34 PM by Andreas Kampianakis

    Penultimate summary gone wrong.!

    Andreas Kampianakis

      Hello world, I have a situation where I need to calculate the summary last-1 (pic 1) but when I use the command lookup(sum[],last()-1) I see what you'll see on picture 2.
      Any ideas people?
      (sorry for the lack of workbook but data are quite confidential)
      Thanks people I hope the pics help the situtation!