Specific Row value

[AS]

Hi Experts,

I'm having trouble in a small task. I need to divide the no of values with the constant value.

in Cal column I need I'm dividing sales with the total sales ex- 500/1034, 4100/1034 

so my main trouble is I'm unable to pick up 1034 value for the calculation. Could you guys please help.

Category	doc no	sales	Cal
Blue	103	500	0.483559
Green	102	4100
Yellow	101	123
		1034

[atcodedog05 · Accepted solution]

Hi @AS 

Use append tool instead

Workflow:

Hope this helps : )

[tinothemonkey · Accepted solution]

Hello There, please see attached for my solution. Hope you find it useful.

See below image for workflow and sample output, thank you!