hi, all, this will be my first question posted on community. I'm hoping to get some help on a workflow I'm working on.
I have two data set. The ABC, LLC file contains entity name and related income data. The partner data file includes entity names and partners in each entity and their ownership% in each entity.
I'm trying to joint two files by entity name and then allocate income line items based on their ownership %. I've attached what I built so far and I'm having trouble figure out the income allocation part. In excel, I can multiply the income cell by the ownership % cell but I'm not sure how to do that in Alteryx without transposing them into columns. In the end, I would like to keep the format where entity income on the left side and partner allocation on the right side.
Thanks in advance for the help!
