3 Replies Latest reply on Jan 24, 2018 12:22 PM by Shinichiro Murakami

    Work Around for Level of detail expressions cannot contain table calculations or the attr function

    chakradhar kakani

      Hello Guys,

       

      Im trying to figure a solutions for Table Calculations. but i was getting a error when i was trying to use one table Calculations field in another table calculation field "Level of detail expressions cannot contain table calculations or the attr function"

       

      Below is the Calculations

       

      [Total Goal] =

      countd(Customer Number) * (1/ ([Company Univ Non X (Market)] / (if [Company Univ] = 0

      THEN [Company Univ Non X (Market)] else [Company Univ] end )))

       

      [Company Universe Non X (Market)] = total(sum({ FIXED [Market] : MAX([nonX_mktUE])}))

       

      [Company Universe] = total(sum({ FIXED [Market] : MAX([Company UE])}))

       

      Now im trying to use this Table Calculated [Total Goal] in new [New Total Goal] Formula is {Fixed [Nwtrk] : [Total Goal] }

       

      But im getting the error "Level of detail expressions cannot contain table calculations or the attr function" can some one please help me

       

      Thanks