on 2024 Nov 27 11:34 AM
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.
Request clarification before answering.
| User | Count |
|---|---|
| 18 | |
| 6 | |
| 6 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.