5 Replies Latest reply on Oct 14, 2016 12:20 AM by praveen p

    Aggregate and Non aggregate mixing issues

    sakthie tm

      I have 2 dimensions named type(string) and count(string) in my Database.I am converting count from string to integer using INT().Using Count i am calculating percentage a new calculated field which will be based on Type i.e., I have three attributes in my Type name Inbound,Call adherence PER,and total calls

       

      count_total=  INT([Count])

       

      Incound =

      IF ([EDS Call email Type]="Inbound")

      THEN

      [Count_Total]

      END

       

      Total calls=

      IF ([EDS Call email Type]="Total calls")

      THEN

      [Count_Total]

      END

       

      Percentage = SUM(Inbound)/SUM(Total calls)

      The problem i am getting is I want to load Count in Inbound and Total calls and percentage in Call adherence PER os i gave the condition as

       

      IF(Type='Call adherence PER')

      then percentage

      end

      But this gave mixing aggregate and non aggregate error So i changed the calculation as

      IF(ATTR(Type)='Call adherence PER')

      then percentage

      end

      But now only NULL values are getting populated

      I need to resolve this