Hi,
Can someone please guide me, how can we add one more record in the below table which would be sum of all FX Forward records just like expected output table.
Input table:-
Sector | Long | Short | Gross | Net |
FX FORWARD_DKK | 1.85 | 1.85 | -1.85 | |
FX FORWARD_EUR | 5.2 | 5.2 | 0.1 | |
FX FORWARD_GBP | 0.81 | 0.81 | -0.81 | |
FX FORWARD_NOK | 1.68 | 1.68 | 1.68 | |
FX FORWARD_PLN | 0.92 | 0.92 | 0.92 |
Desired output:-
Sector | Long | Short | Gross | Net |
Derivatives | 10.46 | 0 | 10.46 | 0.04 |
FX FORWARD_DKK | 1.85 | 1.85 | -1.85 | |
FX FORWARD_EUR | 5.2 | 5.2 | 0.1 | |
FX FORWARD_GBP | 0.81 | 0.81 | -0.81 | |
FX FORWARD_NOK | 1.68 | 1.68 | 1.68 | |
FX FORWARD_PLN | 0.92 | 0.92 | 0.92 |
Solved! Go to Solution.
Here is a way of doing it using the Summarize tool and Union tool - i've created new columns where they might not exist after the Summarize Tool, sorted into the right order, and adjusting the output order from the Union after unioning on position
Note: you'd have to adjust the workflow if/when data appears in the Shorts column but this should give you enough to go on
@davidskaife thanks! this is worked