Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
Topic: usage calculate Posted: 07 Apr 2017 at 2:47am
Have one question about how to get totalvisits(include both with/no medicine orders) from visits only with orders:
Current(sql code for visits w orders, so usage is 100% which is incorrect)
Name totalVisits TotalOrders Usage
Eric 1 1 100%
David 3 3 100%
Eva 5 5 100%
Need to be:
Name totalVisits TotalOrders Usage
Eric 10 1 10%
David 3 3 100%
Eva 25 5 20%
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
Posted: 07 Apr 2017 at 3:01am
basically there are 2 situations: (1) pull all visits, then filter what needs, or (2) only pull one with orders, but do not know how can get total visits.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged