3 Replies Latest reply on Aug 9, 2018 6:38 PM by swaroop.gantela

    Fixed Calcu

    Tony Phan

      Hi,

       

      I'm trying to do a fix table calc. I want to show the "JP" set of numbers on the rest of the rows. Where it shows 11,515,097 to show 362,387 and 6,534,143 to show 193,824.

       

      The formula below is working but not the way I want it to work. Please help!

      {FIXED   [FiscalQuarter], [PRODUCT_CATEGORY], [JP]: (Sum([Adjusted List Price]))}

       

       

        • 1. Re: Fixed Calcu
          Naveen B

          Hi Tony ,

           

          Write a calculation like below

          {{FIXED   [FiscalQuarter], [PRODUCT_CATEGORY], MAX(if [JP]="True" then JP else null end): (Sum([Adjusted List Price]))}

           

          this will give the O/P like you want

           

          Hope this helps kindly mark this answer as correct/helpful so that it will help others

           

          BR,

          NB

          • 2. Re: Fixed Calcu
            Tony Phan

            Sorry I get an error for this. "You can not use an aggerated expression as a dimension because it is a measure"

             

            max(if [JP]="True" then [JP] Else null end)

             

            I even did "max(if [JP]="True" then JP Else null end) " and it didn't work.

            • 3. Re: Fixed Calcu
              swaroop.gantela

              Tony and Naveen,

               

              Sorry for jumping in.

               

              One other method would be to try the conditional on the other side:

              {FIXED  [FiscalQuarter], [PRODUCT_CATEGORY] : Sum(IF [Update Theater]="JP" THEN [Adjusted List Price] END)}

              1 of 1 people found this helpful