Island Calendar in straight Table

[tchovanec]

I have an island calendar in my application. This calendar is used to drive many expression that I have. I am trying to create a straight table that will have the island calendar date as a dimension along with a few expressions. I cannot get it to work correctly. Below is what I get now. It is aggreagating everything and the counts are the same for each day.

The expected result would be 1 for each day. Below is the set analysis I am using for my expression.

COUNT

(DISTINCT
{<
LINE = {1}
,ED_DISPOSITION_C = {101}
,EVENT_TYPE = {50,65}
,ED_DISPOSISTION_TYPE =
,DT_PAT_ADMIT = P(ISLAND_CAL.Date)
>}
SOURCE_VISIT_NO
)

I appreciate any assistance. Thank you

[tchovanec · Accepted solution]

I figured it out.

COUNT

(DISTINCT
{<
LINE = {1}
,ED_DISPOSITION_C = {101}
,EVENT_TYPE = {50,65}
,ED_DISPOSISTION_TYPE =
>}
IF(DT_PAT_ADMIT = ISLAND_CAL.Date,SOURCE_VISIT_NO)
)