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,