I have a thing called Senha, and it has 10 columns called Senha #1 through Senha #10. I want to go through each of them for a specific thing and count the total number of 4s.
I have tested the Search for Senhass:first item’s Senha #1 is 4: formatted as number, and it is returning correctly with a 1, so I know I’m accessing the right info and it is a number type. I even tested adding an arbitrary integer like 2 to it, and it is able to give me the right sum.
Further tests show that only when the last Senh #x in the expression has a 4, will it return a 1 as the overall sum. It’s like it is only considering the last format as number in the chainned expression.
Any idea on how to solve this?
See below my screenshots where I’m testing only senha #1 through senha #3
