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.