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

    Expression %

    Jason Westwood

      Hi,

      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

       

      Thanks