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
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