Reallocate a line of data based on fixed percentages

[kebinger]

Hi,

I have an output with three lines of data. See below for an example:

Mapping	Output
X	500
Y	800
Z	100

I want to be able to set up my workflow so that I can reallocate Z so that 25% of it goes to X and 75% of it goes to Y, with the final output expected to be as such:

Mapping	Output
X	525
Y	875

What's the easiest and most efficient way to go about  this?

[ChrisTX · Accepted solution]

@kebinger the attached workflow is fairly easy.  Just one of many ways to do this.

Chris

[kebinger]

That worked! Thank you for the help, Chris.