2 Replies Latest reply: Feb 6, 2013 4:38 AM by Jonathan Brough RSS

    calculating time values and having null values.

    andries Bos

      I'm loading time values from an excel spreadsheet: however not all of the time values are in the xls sheet present at time of rebuild.


      I would like to show in different tables/ charts the calculated (sum) values of two time values ; despite one that could be empty (null?)


      =Sum(time1 + time2)


      This will work when time1 and time2  both have a value, but would fail when one of them is empty.


      =interval(time1 + time2) however would work but as this is a calculated value, this could not be shown in a straight table.


      I'm looking for two solutions: one to be used in a chart


      and one within the loading script.


      using my script :

      interval([time1] + time)   AS Totaaltime,

      does not seems to work.


      what is the best practice dealing with null values?