Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
SOLVED

Specific Row value

AS
8 - Asteroid

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.

 

Categorydoc nosalesCal
Blue1035000.483559
Green1024100 
Yellow101123 
  1034 

 

2 REPLIES 2
atcodedog05
21 - Polaris

Hi @AS 

 

Use append tool instead

 

Workflow:

atcodedog05_0-1635314653158.png

 

Hope this helps : )

 

tinothemonkey
5 - Atom

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

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

 

tinothemonkey_1-1635315434842.png

 

 

tinothemonkey_0-1635315392844.png