Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Member Formula is not working correctly after moving it to a upper level hierarchy

edited Nov 14, 2019 5:17AM in Planning 11 comments

Content

Hi All,

There is an account "A" which uses a member formula is set to dynamic calc. This member formula refers to two calculated values from two other dynamic calc accounts "B" and "C" to calculate results.It is as follows.

A=B*.6 + C*.4

Account A, physically located under the same hierarchy (H2) as same as B and C. Account A is also placed below of both B and C accounts. We moved account A to a upper level hierarchy (H1) as per our requirement and ran ad hoc report. Now what was working before is not working correctly. What i understood was member formula is working correctly only if account A is placed under both B and C source accounts. why is this? is that the standard behaviour? Highly appreciate your responses.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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