cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Sap Webi Universe formula to calculate the total number of re-admission patients within 14 days

Raz11
Explorer
0 Kudos
158

Hi Experts,

 

I want a Sap Webi Universe formula to calculate the total number of re-admission patients with the same diagnosis within 14 days of discharge.

Note: I don't have specific diagnosis. I have admit date, discharge date

 

I try these formulas, but I receive an error:

1) =Sum(If [Diagnosis Description] = Next([Diagnosis Description]; [MRN- Organization]) And
(Next([Admit Date & Time]; [MRN- Organization]) - [Discharge Date & Time]) <= 14 Then 1 Else 0)

 

2) =If ([Diagnosis Description] = [Diagnosis Description] ForEach ([MRN- Organization]))
And (DatesBetween([Admit Date & Time]; [Discharge Date & Time]) <= 14) Then "Readmission within 14 days"
Else "Not Readmitted"

 

Regards.

Accepted Solutions (0)

Answers (0)