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

help with @Sumrange across two dimensions

in Planning 11 comments

I have an existing formula that looks like this:

Fix(Dim1_member, Dim2_member)
AcctX = @PRIOR(AcctX→noDept→TotalDim1→TotalDim2)

Endfix

What I'd like to do it change the formula so that I don't cross dim on the "Total" members ( "TotalDim1→TotalDim2) but instead I grab the sum of the level 0 members under each. I having trouble formulating that.

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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