Starting point I mean
1 of 1 people found this helpful
I agree with Deepak Rai, we are not clear about what's your starting point.
According to your description, when a person previously said improved and then if the next visit saying stayed the same means improved, we can get a calculation to work out this logic as shown in below snapshot (highlighted with person id 9 and 17).
But what about 19, is there any business rules behind?
Although all results are w.r.t to the first result for each person, aggregating those would be a problem in the way the results are listed. Hence I thought of a business logic to aggregate this:
For every Person,
1) If all results/person are Stayed the same, then only should final result for that person be "Stayed the same"
2) If Worsened/Improved are in the result set for a person, the final result should be the latest Worsened/Improved result for that person.
Eg: Person 14 final result -> Stayed the same, as per (1)
Person 19 final result -> Worsened, as per (2)
Person 17 final result -> Improved, as per (2)
Then I would aggregate the 'final results' per person to get an overall picture. I think this covers all possibilities for the results. If someone can guide me on how to implement this in a Calculated field, that would be terrific. Thanks.