A couple of months kenhamady suggested creating a {@Null} formula in order for my If then formula to work. Well for some reason it isn't working anymore. My report is up for review on Monday or Tuesday and my figures are calculating incorrectly.
I am trying to count cases where LOS>=7. I've tried if( {los}>=7 then 1 else 0)
and then summed on that formula.
Currently the formula is...
step 1
If({@cert_days}>=7 then {case_number} else {@Null}
step 2(admits)
DistinctCount(step1)
{@Null} is blank
and my Days field is based on this
step 1
If {@cert_days}>=7 then {@cert_days} else 0
step 2(days)
sum({step1}, {facility id})
the days are corresponding with the distinctcount however there should be 5 admits and 54 days, but there are 1 and 16 days.
I am trying to count cases where LOS>=7. I've tried if( {los}>=7 then 1 else 0)
and then summed on that formula.
Currently the formula is...
step 1
If({@cert_days}>=7 then {case_number} else {@Null}
step 2(admits)
DistinctCount(step1)
{@Null} is blank
and my Days field is based on this
step 1
If {@cert_days}>=7 then {@cert_days} else 0
step 2(days)
sum({step1}, {facility id})
the days are corresponding with the distinctcount however there should be 5 admits and 54 days, but there are 1 and 16 days.