Is there an argument limit for FIRSTNONBLANK?

[JRood]

Hi everybody!

I had a question about the FIRSTNONBLANK equation to make a new row.  I have used it very effectively but I sent it to a colleague to share for a similar piece of work.  The equation being used is 

FIRSTNONBLANK( @LOB1@ , @LOB2@ , @LOB5@ , @LOB4@ , @LOB3@  )

But it's only returning the data for @LOB1@ and none of the others.  The logic seems right and like it should be working.  Please share any advice or thoughts you may have.

[Melanie]

Glad to hear all is working. Please let your colleague know that Pax Pros are standing by here in the Community if any other issues arise 🙂 

[JRood]

Those are the actual column names used.  It looks like they eventually got it to work; I went in and the formula still looks pretty much the same.

FIRSTNONBLANK(@LOB1@ ,@LOB2@ ,@LOB3@ ,@LOB4@ ,@LOB5@ )  

Again, these are the actual column names.  Not sure why this worked when the previous didn't. 

[Melanie]

Hi JRood, the equation should be fine for the five columns you reference (not a limitation). However, would you mind posting back the actual column names that your colleague has in his/her dataset?
thank you