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

Allocation Equally

Summary:


Content (please ensure you mask any confidential information):

Hi


I have 10 entities, and 4 sectors. For ex


Entity A Sector 1

Entity B Sector 1

Entity C Sector 1

Entity D Sector 2

Entity E Sector 2


I have an amount in begbalance in fy 24. for ex : 1091063.

i need this to be allocated for entities equally within the sector which is selected by the user.



For ex : if user selects sector 1, then this amount should be distributed equally within entity a,b,c

if user selects sector 2, then this amount should be distributed in entity d and e


Currently sector is an attribute dimension in the entity dimension. I want a function or something to calculate the no of entities relating to a sector.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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