Hi there - Using multi row formula tool how do get expected output from below sample data. I have provided below input data and expected output.
Please help.
INPUT :-
Sector | Gross | Net |
Maturity 1 | 37.28 | 24.84 |
Maturity 3 | 48.27 | 48.27 |
Maturity 5 | 59.26 | 71.7 |
Maturity 7 | 70.25 | 95.13 |
Maturity 10 | 81.24 | 118.56 |
Long | 92.23 | 141.99 |
Maturity 1 | 103.22 | 165.42 |
Maturity 3 | 114.21 | 188.85 |
Maturity 5 | 125.2 | 212.28 |
Maturity 7 | 136.19 | 235.71 |
Maturity 10 | 147.18 | 259.14 |
Short | 158.17 | 282.57 |
Maturity 1 | 169.16 | 306 |
Maturity 3 | 180.15 | 329.43 |
Maturity 5 | 191.14 | 352.86 |
Maturity 7 | 202.13 | 376.29 |
Maturity 10 | 213.12 | 399.72 |
EXPECTED OUTPUT :-
Sector | Gross | Net | FLAG |
Maturity 1 | 37.28 | 24.84 | 0 |
Maturity 3 | 48.27 | 48.27 | 0 |
Maturity 5 | 59.26 | 71.7 | 0 |
Maturity 7 | 70.25 | 95.13 | 0 |
Maturity 10 | 81.24 | 118.56 | 0 |
Long | 92.23 | 141.99 | 1 |
Maturity 1 | 103.22 | 165.42 | 1 |
Maturity 3 | 114.21 | 188.85 | 1 |
Maturity 5 | 125.2 | 212.28 | 1 |
Maturity 7 | 136.19 | 235.71 | 1 |
Maturity 10 | 147.18 | 259.14 | 1 |
Short | 158.17 | 282.57 | 2 |
Maturity 1 | 169.16 | 306 | 2 |
Maturity 3 | 180.15 | 329.43 | 2 |
Maturity 5 | 191.14 | 352.86 | 2 |
Maturity 7 | 202.13 | 376.29 | 2 |
Maturity 10 | 213.12 | 399.72 | 2 |
Solved! Go to Solution.
@binuacs -- thank for your help. Your workflow works perfect as expected. However, same expression when I am using in my workflow, it is throwing attached error. What could be the reason.
@binuacs -- Please ignore above comment. This is resolved, my new field data type was incorrect. after correction result is as expected. Thank you so much.