Calculating the row with value

[passerbyrtw]

Hello,

Would like to check is there any ways of calculating the number of rows that contain value.

For example the table is like:

Customer_Number  Referee1     Referee2    Referee3       Referee4

1234567                  123              B123          C123              Dieter

9876543                  A246            B246          C246

1357911                  A357             B357

2468100                  A987

And the expected output be like:

Customer_Number  Referee_Number

1234567                    4

9876543                    3

1357911                    2

2468100                    1

The referee_number should be the number of Referee1 to 4 that with value.

Looking forward for the suggestion!

Thanks!

Raymond

[flying008]

Hi, @passerbyrtw 

FYI.  (Count non null by [Value])