AnsweredAssumed Answered

create a report sorting by year

Question asked by RobertT on Mar 30, 2015
Latest reply on Apr 1, 2015 by RobertT

Title

create a report sorting by year

Post

I have a list of patients with 3 different date ( two different years 2014,2015)  Im trying to calculate the total number of scripts written (different amounts per patient per record).  

my problem is I can calculate the year(dateservice=2014)   and separate field calculation year(dateservice=2015) and use it as subsummary for numberscripts field... but i am getting boolean values and not the total number of scripts per given year.     i have a total 159 scripts (  random number scripts written in a "scripts"  field)  and 3 records per patient with the patient having 3 different visits  where I have a "date service"  field  ...   any guidance would be appreciated

 

 

 

 

Outcomes