2 Replies Latest reply on Apr 25, 2018 4:12 PM by Deepak Rai

    Formula error (LOD)

    suvas.chandra

      {FIXED [Portfolio 2],[LT City] : SUM([LT ExposedTotalInvested])}

       

      It is showing error in [Portfolio 2] -----(Error: Level of Detail cannot contain table calculations). But how will I do it without table calc ?

       

       

      This is portfolio 2:

       

      If MIN([Wideview (Vis Wide View - 9.30.17 - Refresh 04.17.18)].[Informant Key 1]) = MIN([Informant Key 2]) Then MIN([Wideview (Vis Wide View - 9.30.17 - Refresh 04.17.18)].[Portfolio]) END

       

       

      Any help ?