Hi,
I am looking to find away to evenly spread costs over multiple lines based on 2 pieces of criteria.
In the attached example I have $1m and want to look up the project number in a list and find all IDs associated then look up the status' and spread the $1m over all Ids which are noted as Active, not allocating the costs to any cancelled.
Any advice or help with this is appreciated.
Thanks
Bookmarks