Pivot table not sub totalling properly

[#1]

Hello Everyone:

I have an issue where a sub total in a pivot table isn't calculating properly and I'm not sure how to fix my expression. I have a calculated dimension and in the expression I need to turn a negative number into a positive for one of the dimensions. I've done this with the following expression:

If([ACSEGVAL01] >= 41000 and [ACSEGVAL01] <= 46500,

money(sum({<Scenario={'Budget'}>} Amount)) * -1,

money(sum({<Scenario={'Budget'}>} Amount))

   )

If the "problem" dimension is expanded all the numbers are positive but the sub-total for this expression/dimension is still negative.

I'm not sure how to resolve this.

Thank you!

[jvitantonio]

Can you attach yourapplication?

[#3 · Accepted solution]

Try changing to this:

money(sum({<Scenario={'Budget'}>} Amount * If([ACSEGVAL01] >= 41000 and [ACSEGVAL01] <= 46500,-1,1)   ))