Checking Negative values across Multiple columns

[PKoya]

Hi,

I am trying to figure out what would be the best way to check for negative values within multiple columns (columns by month).

If there is any negative value in one or more columns, I want to flag it as Negative (as shown in the example blow).

The catch here is that the number of columns can change each time we run the workflow so I am unable to figure out what's the best way to address this.

Sample data is attached

[patrick_digan · Accepted solution]

@PKoya  The key is to Transpose your data (making sure that the dynamic box is checked at the bottom):

[PKoya]

Hi @patrick_digan,

Thank you for your solution. It worked like charm.