Get a Count of Columns with a value

S

Simone

Have a table with data set up as follow:

Business Unit Jan Feb Mar Apr May etc..
Finance .35 .54 .32 .21 .06
HR .25 .45 . .15 .65

Need to find out for each business unit, the # of columns(Months) with a
value in it. Using previous example, I want to end up with:

Fiance 5 (There are 5 values)
HR 4 (There are 4 values and 1 null)

Also is there a way I can sum up the values in each row (i.e Finance total
1.48), without having to manaully add fields (Jan+Feb+Mar+Apr+etc.)

Thanks,
Simone
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top