2 Replies Latest reply: Aug 22, 2013 9:53 AM by Kris Vliegen RSS

    max datetime per station

    Kris Vliegen

      Hello,

       

      I'm working on a dashboard for fuelstations.

      They will see how much fuel there is in a tank per station and per fueltype.

      The volume is measured several times a day on different timestamps per station.

      The defenition of stock is

      =num(sum( { $ < DateTimeNum =  {'$(=Max(DateTimeNum))'} , CalYear = , CalQuarter= , CalMonth=, CalDay=  >}Stock15),'#.##0,00 L')

       

      As you can see in the picture he takes the max(dateTimeNum) of all the shops. So only for shop 150 (the shop with the highest datetime is showed. Does anybody knows how I can get the latest stock of all the shops?

       

      Regards,

      Kris

      Stock.JPG.jpg