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

Account Not Retrieving for Summary Periods and DTS

Received Response


Some accounts are calculating quarters, year total, and dynamic time series and retrieve correctly. Other similar accounts return nothing.

Content (required):

We have a series of accounts to calculate average values. They have all the same account properties. And the same basic member formula structure: @AVGRANGE(SKIPNONE,("A5101002" + "A5101013"),@REMOVE(@CURRMBRRANGE("Period",LEV,0,,0),"BegBalance"));

Some of these accounts return correctly for all periods and DTS and some do not. Except the member formulas (which are structurally the same), the account properties are identical.

Does anyone have an idea why?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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