2 Replies Latest reply on Jan 3, 2013 1:23 AM by Amarendu Samal

    Calculating a count off a Concatenate

    SILVIO MARTINEZ

      The concatenate formula: 

       

      str([MedRecNum]) + ' - ' + str([PtAdmitDate]) + ' - ' + str([PtDischDate])

       

      Example:

      Medical RecordAdmission DateDischarge Date
      108244-19-2012

      4-27-2012

      10824

      4-19-2012

      4-27-2012
      108244-19-2012

      4-27-2012

      108244-2-20124-6-2012
      108244-2-20124-6-2012

       

      Person came in on 2 separate occurences and the count should be 2.  Not sure if formula for this is correct?  I think I need count formula off the concatenate formula?  Each admission and discharge for each patient should be 1 count.  Any ideas?