5 Replies Latest reply: Dec 16, 2013 5:40 AM by Gysbert Wassenaar RSS

    Complex Expression

      Hi All,

       

      I have a bit of a challenging situation which I thought I would ask some of the more experienced app developers for some assistance.

       

      I have a spreadsheet which contains some odometer readings. I have created a dummy version of the data which I have attached as it may be a bit hard to explain in just words. I am trying to set up an app that analyses mileage, i.e. mileage today - mileage yesterday by field staff, as well as mileage between certain periods eg between July & Sept if I selected these in a list box.

       

      The challenge comes in when you don't have an odometer reading for a particular day, mileage today - mileage yesterday no longer works. Also there is an aggregation problem if you ever have a situation when you don't have an odometer reading on the last or first day of the month.

       

      Not sure how to get round this, but was thinking if there was a way to insure that there is a value for each employee for the odometer reading, by converting every blank to the last record reading for that employee (date wise) in an upload expression, or can this be handled some how when doing the actual expression for an object?

       

      Any thoughts or guidance would be greatly appreciated.

       

      Thank you

       

      Herbiec09