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

Advise needed to compose Member Formula driver base expense account

edited Feb 8, 2021 2:11PM in Planning 7 comments

Summary

formula advise needed for a target parent level member multiplied by a level 0 working member

Content

Hi

I'm having difficulty composing a member formula for driver based calculation.

the formula is 'Units' * 'standard Cost Estimate'

I can come to a result when i do my input on both the same version and both the same cost centre. But the cusomer does the input on different levels...

The standard cost is on parent level of cost centre, hence I'm using the Target Version

The units is on Level0Descendants of cost centre and hence is 'Working' Version.

The formula I have that works is when I use for both members working and level0descendants. or Target and Parent level but not when you mix.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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