Cross Tab average column on non zero values

building reports crystal reports
1

Hi
I have a Cross tab report which shows the billing hours of users by week wise. In the database I have a date field and Billing hours field in which the user will enter the billing hours.

In my report I create a Week formula so that it will return the week number for this year upto current date.

My cross tab columns and Rows

Username Weeknumbers Average
1 2 3 4
X 44 40 0 41 41.6
Y 0 0 0 45 45
Z 40 40 0 23 34.3

Note: I need to Calculate the average only for the Non zero billing hours week
I am using Crystal report XI

If anybody knows the solution please help me

Regards
Mani.R

jkmarvelmani (BOB member since 2006-08-19)

2

Before you read on, please know that I am NOT a fan of cross-tabs because they do not permit very much complexity. They are great for simple reports and that is about all.

If you build your report without using the cross-tab, you will then be able to create a formula to count up the non-zero billing hours and use that to obtain your average.

Chamsin :us: (BOB member since 2008-06-05)