8 Replies Latest reply: May 26, 2016 3:57 AM by Onno van Knotsenburg RSS

    straight table expression query

    Jaya Budihal

      Hello All,

       

      I have one more query

      I have been calculating the the difference between two dates in the straight table.now i want to only show values which are in negative and show 0 where the value is positive.

      Please help me with this.not sure how to do this.

          

      order idorder_dateorder end dateshipment datedelivery date(orderdate - shipment date)
      1 -1
      2 -2
      3 2
      4 3

       

      Thanks & Regards,

      Jaya