Using @SUMRANGE to provide amount to @ALLOCATE
The following statement assigns the value I expect to see for Budget:
"Budget" = @SUMRANGE("FY17"->"Forecast_1"->"Final"->"YearTotal",@UDA("Account","NOALLOC"));
However, the same expression, planted in this @ALLOCATE statement assigns nothing to budget
"Budget" = @ALLOCATE(@SUMRANGE("FY17"->"Forecast_1"->"Final"->"YearTotal",@UDA("Account","NOALLOC")),@SIBLINGS("Supply_Chain_Planning_Input"),"FY17"->"Forecast_1"->"Final"->"YearTotal"->"A60000",,share);
Can you see the error in my syntax? Ultimately, I want to use this expression to back out the total for tagged accounts from an allocation.
Thanks,
Rich
0