Move or Allocate by department and vendor
Summary:
Content (please ensure you mask any confidential information):
I am trying to allocate or move some expenses based on two components: departments and vendors. I need to move them within the same department, but to a different vendor. I need this to be done for all base level departments/vendors.
Example: For "Mark" vendor and department D1055 below (3rd line) , I need to allocate from entity 09 (column c) 22% to entity 10 (column d) and 68% to entity 01 (column e). It needs to go into vendor "corporate allocations" and D1055 department.
I used the business rule below, but it isn't working. (I ran an agg after running the rule)
0