Dynamic field name in a filter expression

[Nmetzgen1]

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

[MSalvage · Accepted solution]

@Nmetzgen1,

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

[danrh]

Another option :)

[Nmetzgen1]

Thank you both for your help!!