Forum Discussion
Transfer amount from one object to another
Hi felixG ,
Can you provide more information?
1# How do we group these row and why A2, A4, A5 is blank group.
2# How do we get the "send" value and why A2, A4, A5 is blank value.
3# Can you explain the formula of "receive"?
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
thanks for your reply.
#1 each object can be only a sender or a receiver of amount. the groups (group table) define which object acts as a sender (object A1 & A3). depending on the groups, the costs are then distributed to the recipients. i.e. if the object is part of group 2, the costs will spread across A4 and A5 depending on the given percentages in allocation of table "groups".
A2, A4, A5 is blank group cause they dont act as a sending object.
#2 the send value is given in table 1) import. its the sum of the amount. i.e. A1 is sending 50 to group 1 (= A2 = 100%).
A2, A4, A5 is blank value cause they dont act as a sending object.
#3 the formula of "receive" is the result of the tables before. i try to explain it in formula:
> first, check if the object belongs to a group (table matrix)
> if the object is part of a group, find the recipients of the costs (table groups)
> allocate the sum total of amount (table import) by the given percentage in table groups to the given object in table groups
> The total of A3 is 250. A3 is part of group 2
> group 2 divides the costs into the objects A4 and A5 (50 percent each)
> A3_new = 250-250; A4_new = 50%*250; A5_new = 50%*250
Please ask if you need more information.
Best Regards,
felix