report2000
Technical User
Hi,
I have the following sample Data Set
JobCode Region HourlyRate
------- ------ ----------
11 North $30
21 North $30
31 South $34
44 South $35
44 South <Null>
44 South $28
I am grouping by Region and then JobCode
Here is the formula I used to calculate the "NbrOfFacilities"
---------------------------
if isnull(HourlyRate)
then 0
else
1
---------------------------
Then I use the InsertSummary feature to sum the '1s'.
----------------------------
I would like to count only jobcode 44 once.
-------------------------------------------
How can I incorporate the distinctcount(jobcode) with my formula?
Thank you.
I have the following sample Data Set
JobCode Region HourlyRate
------- ------ ----------
11 North $30
21 North $30
31 South $34
44 South $35
44 South <Null>
44 South $28
I am grouping by Region and then JobCode
Here is the formula I used to calculate the "NbrOfFacilities"
---------------------------
if isnull(HourlyRate)
then 0
else
1
---------------------------
Then I use the InsertSummary feature to sum the '1s'.
----------------------------
I would like to count only jobcode 44 once.
-------------------------------------------
How can I incorporate the distinctcount(jobcode) with my formula?
Thank you.