Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Volume Allocation

nihou
8 - Asteroid

Hello, I am looking for some help with an allocation formula.  I am trying to allocate by transaction or T-code. 

 

nihou_0-1636431439334.png

 

 Source Data     Desired Ouput     
 TCODEINTOwnVolDed TCODEINTOwnVolDed 
 206B0.00781000.16 206B0.007816.666670.16 
 206B0.0078100-0.08 206B0.007816.66667-0.08 
 206B0.00781001.87 206B0.007816.666671.87 
 206B0.00781002.09 206B0.007816.666672.09 
 206B0.0078100-0.16 206B0.007816.66667-0.16 
 206B0.00781002.63 206B0.007816.666672.63 
 207F0.0152000.32 207F0.01533.333330.32 
 207F0.015200-0.15 207F0.01533.33333-0.15 
 207F0.0152003.74 207F0.01533.333333.74 
 207F0.0152004.18 207F0.01533.333334.18 
 207F0.015200-0.31 207F0.01533.33333-0.31 
 207F0.0152005.25 207F0.01533.333335.25 
 208F20.0233500.48 208F20.02358.333330.48 
 208F20.023350-0.23 208F20.02358.33333-0.23 
 208F20.0233505.61 208F20.02358.333335.61 
 208F20.0233506.27 208F20.02358.333336.27 
 208F20.023350-0.47 208F20.02358.33333-0.47 
 208F20.0233507.88 208F20.02358.333337.88 
 209B0.061501.27 209B0.06751.27 
 209B0.061500.2 209B0.06750.2 
             
    80040.55    80040.55 
             
             

 

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@nihou 
Hope this is what you need.

1109-nihou.PNG

Labels