Distinct Count on a combined text field

Question

I need to identify the number of unique inpatient admissions from claims data. Each inpatient stay can generate multiple claims each with a unique claim identifier. The claims would all share the same admit start date. the claim also has the member id of the member who had the inpatient stay.

I want to count the number of inpatient visits visit for each member regardless of how many claims were submitted for the inpatient visit.

I have attempted to do combine the claim ID with the admit date and want to do a distinct count of that....

------------------------------
Lashell Thomas
------------------------------

MikeTamoush · Answer

Thanks to @Mark Shnier (Your Quickbase Coach) for this bit of code to count combine text fields:

var text value = ToText([Combined Text Field]);

Count(

Trim(Part($value,1,";")),
Trim(Part($value,2,";")),
Trim(Part($value,3,";")),
Trim(Part($value,4,";")),
Trim(Part($value,5,";")),
Trim(Part($value,6,";")),
Trim(Part($value,7,";")),
Trim(Part($value,8,";")),
Trim(Part($value,9,";")),
Trim(Part($value,10,";")),
Trim(Part($value,11,";")),
Trim(Part($value,12,";")),
Trim(Part($value,13,";")),
Trim(Part($value,14,";")),
Trim(Part($value,15,";")),
Trim(Part($value,16,";")),
Trim(Part($value,17,";")),
Trim(Part($value,18,";")),
Trim(Part($value,19,";")),
Trim(Part($value,20,";"))
)

------------------------------
Mike Tamoush
------------------------------

Sign up

Login to the community