How to distribute the value of line item equally.

riyazpasha

Hi,

I have 2 line items where in one is Boolean and other is numeric(percentage format). if the Boolean item is checked for that property then the value has to be zero for that particular property and its value to be equally distributed to the other properties.

 

for ex: In the screenshot the %alloc of the property 1 is 10% if its sold the 10% should be equally allocated to other properties and property 1 should become 0%.

 

Any suggestions on how to do this.

 

S1_99276.PNG

JaredDolich

@riyazpasha 

Awesome! How about one of these idea:

• Use Breakback
• Use a System Module

BreakBack - use breakback if you need the allocated value to be editable.

Here, I edit the parent "300" and it automatically allocates evenly since all the child records are zero.

 

Use A System Module.

• Create a system module for your child list
• Add a list formatted line item for the PARENT
• Add a counter so we can sum up the children reporting to the PARENT. Put a "1" in the formula and call it "Count" (sorry, I didn't show this line item below)

In your planning module use the aggregate values from your system module to properly allocate evenly to the children.

Stand up and Cheer!! You did it!

 

System Module