8 Replies Latest reply on Dec 22, 2016 12:33 AM by lei.chen.0

    How to calculate Countd(orderid)

    Jilani Shaik

      In the following attachment i hav region and order id

       

      region,orderid

      east,100

      west,200

      west,100

      east,300

       

       

      when i calculate countd(orderid ) it will get count as 4 but i need 3 only

      and my question is when ever the order id is same for both regions i need to calculate only east region, if not calculate both regions