1 Reply Latest reply: Nov 13, 2012 7:36 AM by GlennS_3 RSS

    Convert calc script to MDX member formula

    925549
      Hi,

      I need help in converting the below calc script to a MDX formula. Any help will be greatly appreciated.

      IF (@ISLEV(Market, 0)) A0000001 / AS506002 ; ELSE @SUMRANGE(AS509303, @RELATIVE(@CURRMBR(Market), 0)) ; ENDIF
        • 1. Re: Convert calc script to MDX member formula
          GlennS_3
          user1993419 wrote:
          Hi,

          I need help in converting the below calc script to a MDX formula. Any help will be greatly appreciated.

          IF (@ISLEV(Market, 0)) A0000001 / AS506002 ; ELSE @SUMRANGE(AS509303, @RELATIVE(@CURRMBR(Market), 0)) ; ENDIF
          Try
          Case When ISlevel([Market].currentmember(0)) then
          [A0000001]/AS506002
          Else
          sum([Market].currentmember.children,AS509303)
          END