You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

@XRANGE not work properly

in Planning 27 comments

Hello everyone,

I am using XRANGE function in my rule to calculate the average amount.

Under my Period dimension, I have YearTotal hierarchy and YearTotal_Input alternate hierarchy :

When I used XRANGE, it scanned all the Period dimension (include this hierarchy) , so my data is doubled.

My question is:

How can I remove the alternate hierarchy from @Xrange function?

I tried to put @AVERAGE(SKIPNONE, x, @REMOVE(@XRANGE(FY23→Jul, FY24→Mar) , @SHARE(@RELATIVE(YearTotal_Input,0)))

But it gave me no result. This function @SHARE(@RELATIVE(YearTotal_Input,0)) seems remove both base and share member.

Thanks and have a nice day!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!