3 Replies Latest reply: Jun 22, 2016 11:26 AM by Colin Albert RSS

    Expression %


      I wonder if you can help me I have a Chart that I'm currently running this expression on:


      =count ({<[OC] = {'C'}>} Distinct Order)


      this is counting the orders that only have the OC field set to C


      what I'm trying to achieve is  this but then divide it by total orders to work out the % of orders going via this method if that makes sense


      so for instance when I select a customers name it shows me 30% of there orders when via Method C


      in SQL you would do a simple Count Orders / Orders where OC = C