Pivot Table Expression Cascades when grouped

[cbaqir]

I am trying to figure out what is wrong with my syntax that causes the Variance and Forecast Accuracy to cascade to all rows when grouped by Program/Portfolio but if a single Project is selected, it looks correct.

Single and Correct:

Dimensions:

PROG_PORT

REQUEST_ID

Variables and Their Expressions:

vNewForecastAccuracy  =IF(($(vForecastRound)=0 and $(vActualRound)=0),IsNull(Null()),IF(FABS($(vNewVariance))>1,0,1-FABS(($(vNewVariance)))))

vNewVariance  =IF($(vVariance)=0,0,IF($(vForecastRound)=0,IF($(vVariance)<0,-1,1), ($(vVariance)/ ($(vForecastRound)))))

Thanks,

Cassandra

[#2]

we are going to test somthing.

put in your variable   this expression : IF( FABS($(vNewVariance))>1 , 0 ,1- FABS($(vNewVariance)) )

and show me the result

[cbaqir]

Still null.

[cbaqir]

Ok, after removing the = from the Variables, the vNewVariance is working but vNewForecast is still showing all NULLs.

When I copied the expression into a text box, I see Error: Error in expression: ')' expected.

=IF(($(vForecastRound)=0 and $(vActualRound)=0), IsNull(Null()), IF(FABS($(vNewVariance))>1,0, 1-FABS($(vNewVariance))))

I think the issue is related to FABS($(vNewVariance)) because this alone gives me the same error. Does FABS() not work in this case for some reason?

Is there a way to pinpoint the issue because I can't seem to find it.