2 Replies Latest reply on Jul 8, 2014 7:21 AM by Swetha L

    calculations with aggregate and non aggregate functions

    Swetha L

      In the below attachment i have some data where i need some calculations which i am not able to do


      sum of EcoXpert Insight:

      sum of EcoXpert system :

      sum of value: (NOte: -1 value must  be eliminated)

      count of countries:


      can anyone please help me on this