Get first fieldname name with a value condition
Hi All, I want to have a new column on a table that gives me the first column that has a specific value.
So, I have this
Header 1 Header 2 Header 3 Header 4 Header 5
Name Month1 Month2 Month3 Month4
A 0 0 3 3
B 0 4 0 1
C 0 3 2 1
D 1 0 0 1
I would like to add a column with the name of the first column that has a value higher than 0.
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6
Name Month1 Month2 Month3 Month4 FirstMonthSales
A 0 0 3 3
Month3 B 0 4 0 1
Month2 C 0 3 2 1
Month2 D 1 0 0 1
Month1
So, the FirstMonthSales column should have the first month that has a value higher than 0.
Kindly assist on this. if anyone
