14 Replies Latest reply: Jul 18, 2017 7:19 AM by Pankaj Thakur RSS

    Simple expression help

    Gareth Lloyd

      Morning guys

       

      Quelle surprise, I'm after a little help please.

       

      I’m trying to find the number of PO’s raised retrospectively. Logically, the way to work this out would be to look where the order date is after the invoice date.

       

      My expression is as follows but doesn’t work. I only want it to count the positive values.

       

      count({<[Invoice Date]-[Order Date]={'>0'})

       

      Thanks in advance for any help offered.

       

      Gareth