Decided to dive into the world of array to solve my problem, but have no idea where and how to start.

Problem:

Hospital patients have diagnosis codes attached to the their account.

The account can have no diag. codes, or 1, 2 and even 10-15 of them.

Our system use rank numbers for these codes:

Admitting diag. code - 0
Primary diag code - 1
Secondary diag code - 2

and so on.

The two fields used are:

{TSM910_ICD9_REF.icd9_code}
{TPM318_VISIT_DIAGNOSIS.ICD9_rank_no}

The diag codes are strings and rank numbers are numbers.

From what I understand, I would need a formula to declare the array, a formula to display the diag code, and a formula to reset.

The report is grouped by visit number, and group footer as data placement.

Can someone get me started with creating the 3 first formulas (for example: diag_array, diag_display, diag_reset.

I will also have to create additional furmulas (one for each diag rank)

The report will have one patient record on each line, with diag. codes placed across each line (group footer)

So hopefully we've got some array gurus on the forum that can assist in getting this initial setup done.

Each Diag. code will have to have its own custom formula.

I truly appreciate the assistance.

  


Edited by TorLang - 08 Feb 2017 at 6:03am