6 Replies Latest reply on Apr 10, 2018 11:04 AM by Jim Dehner

    Need help with Calculation

    karishma.velisetty.1

      I have country , customer and status column in data.

       

      I need help with calculation where If all are green its is 100% for country. For eg in US , all customer have green status so its 100%. For UK , out of 2 customer one has amber status so its 50 %.

       

       

      I need below output. Attached workbook.

        

      CountryCustomerStatusPercentage
      US100Green100%
      US101Green
      US102Green
      US103Green
      Uk105Green50%
      Uk108Amber