I held off on asking how to do this until I researched and came up with the attached solution, but would appreciate feedback if this could be done with more sophisticated tools or formulas to enhance my learning. Plus sharing my solution for others.
I want to allocate unassigned sales to other locations, by multiplying the unassigned sales against the quotient of the locations sales over the total assigned sales. I could not figure out a way to accomplish multiplying by a result in a row (e.g., if statement field / row combination based on unassigned's sales). Instead I focused on creating new fields (columns).
Thank you.
