This content has been marked as final. Show 6 replies
I had asked for help on this before and got some great advice which got me close.
Here is a rough example of my data.
Case # LOS
So each case can have multiple rows. But the LOS will always be the same for each record for that case.
So I need to calculate the AVG LOS for the above group of cases data. So I would add (18+7+9)/3. I only want to add the LOS one time for each case.
I have gotten really close. But I have some situations where the calculation is not working correctly.
Any more advice would be greatly appreciated.