Free Trial

Alteryx Designer Desktop Discussions

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

Multiple calculations using Dynamic Formula macro

sonseeahray
8 - Asteroid

I am attempting to find a solution to perform calculations based on 2 tables. It's difficult for me to explain, so I have screenshots to show what I am trying to accomplish. The final base table will contain 1,000s of combinations to perform calculations from.

 

Base table

sonseeahray_0-1581959310142.png

 

 

Lookup table

sonseeahray_1-1581965095174.png

 

 

 

The field I called "Add values" contains the values that need to be added together from the values inthe lookup table. The screenshot is a very small sample. The lookup table will contain about 100 lookup columns.

 

So, for the V-A combo 20069-130115, the "Add values" field would be the sum of the lookup values for those fields, which would result in this calculation

sonseeahray_0-1581966646530.png

=309,619.139

 

I am able to get a single calculation using the Dynamic Formula macro, as in the screenshot below. 

sonseeahray_0-1581968162828.pngsonseeahray_1-1581968205009.png

How would I modify the Dynamic Formula Macro accomplish getting multiple calculations for one V-A?

 
 

This is a sample of what a list of calculations for one V-A combination would be:

sonseeahray_0-1581971333701.png

 

 

10 REPLIES 10
sonseeahray
8 - Asteroid

@danilang Sorry I took so long to accept your solution.

Labels
Top Solution Authors