Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Still null.
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.