on 01-05-2015 2:42 AM
Hello,
I have just started using CP in a healthcare setting. I am trying to put a report together to track patients' lab values from the date the report is opened and the previous 2 days, which will give me 3 days worth of lab values. The results come from a data field called, CollectionDate, and all I want to do is limit that to the current date and previous 3 days. I have found a standard function for this in CP called Last7Days, which works great but I only want the last 3 days of data. I am sure this is a rookie formula, but I have just started using this program. Please let me know if you can help.
Thanks,
George
Hi George,
You could add a Ranking formula to Collection Date and then set a Rank filter option to display the Top 3 Ranked Collection Dates.
With regards
Gill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.