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

# Fixed Calcu

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

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

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

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