Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Dev Space

Customize and extend the power of Alteryx with 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
22 - Nova
22 - Nova

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