@RANGELASTVAL does not like @CURRMBR

@CHILDREN

Hi all,

Please, have a look at the following sample image, specially the highlighted rows:

That image represents what I'm trying to achieve. As you can see, each parent member (Colas, Root Beer, etc) takes the last available value within their children's range. My attempt to calculate this looks as follows:

FIX(jan:dec,Sales,Florida,@CHILDREN(Product))

Actual(

@CURRMBR(Product) = @RANGELASTVAL(SKIPMISSING,@CHILDREN(@CURRMBR(Product)));

)

ENDFIX

However, Essbase returns a validation error: 1200387 Error optimizing formula for [Actual] (line 5): invalid member name

Notice @CHILDREN(Product) returns Colas, Root Beer, etc. What I'm expecting is that when Essbase calculates Colas it takes the last available value from Colas's children. The formula works when substituing