Hi all,
I have created a macro that creates numbered fields based input rows. The new fields are named 1, 2, 3, 4 etc. as the number of new columns depends on the input data the 'name' of the last field is variable.
period | sales | product |
1 | 10 | A |
2 | 11 | A |
3 | 13 | A |
2 | 23 | B |
converts to
product | 1 | 2 | 3 |
A | 10 | 11 | 13 |
B | 23 |
The formula i need to add creates a new field based on value in last field added. (to determine is a product range is discontinued) in the case where only four columns are created, the filter expression is '[3] > 0'. how can i add in a filter that has an expression '['x'] >0' where x is the name of the last field added
product | 1 | 2 | 3 | status |
A | 10 | 11 | 13 | active |
B | 23 | discontinued |
kind regards
Nicholas
Solved! Go to Solution.
Kind of hacky, but I think the attached workflow does what you are looking for. Probably a more elegant way of doing this, but this was the first way that popped into my head.
Hope it helps,
MSalvage
Thank you both for your help!!