Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I currently have this expression in a text box. This is giving me the current number I want.
=SUM(AGGR(IF(FirstSortedValue(
{<
ADMIT_DT ={">=$(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12)))<=$(=MA(ISLAND_CALENDAR.DATE))"},
FLG_Z_PATIENTS = {0},
ISLAND_DEPT.DEPT_ABBR = P(DEPT_ABBR)
>}
DISTINCT DEPT_ABBR,-ADMIT_DTTM)=ISLAND_DEPT.DEPT_ABBR,1,0),MRN,ISLAND_DEPT.DEPT_ABBR))
I then want to put an action on this text box to select the MRN’s. Here is what I have tried with no luck.
='(' &CONCAT(AGGR(IF(FirstSortedValue(
{<
ADMIT_DT ={">=$(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12))) <=$(=MAX(ISLAND_CALENDAR.DATE))"},
FLG_Z_PATIENTS = {0},
ISLAND_DEPT.DEPT_ABBR = P(DEPT_ABBR)
>}
DISTINCT DEPT_ABBR,-ADMIT_DTTM)= ISLAND_DEPT.DEPT_ABBR,1,0),MRN,ISLAND_DEPT.DEPT_ABBR)DISTINCTMRN, '|') & ')'
Can this be done in a text box where I am using the aggr function? Any help would be appreciated. Thank you.
Try this expression for the search string:
='(' & concat(DISTINCT AGGR(IF(FirstSortedValue(
{<
ADMIT_DT ={">= $(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12))) <=$(=MAX(ISLAND_CALENDAR.DATE))"},
FLG_Z_PATIENTS = {0},
ISLAND_DEPT.DEPT_ABBR = P(DEPT_ABBR)
>}
DEPT_ABBR,-ADMIT_DTTM)= ISLAND_DEPT.DEPT_ABBR,MRN),MRN,ISLAND_DEPT.DEPT_ABBR),'|') & ')'
HI THERE ,
first you select MRN in list box then create a newbookmark
now create your text box,go to actions > bookmarks>apply book marks>enter book mark ID
I cannot select the MRN's in a list box because this is all dependent on the number in the text box. If I have 15 in the text box then I want to click the text object and select those 15 MRNs.
Please post a sample document that demonstrates the problem. See this document for how to do that safely: Preparing examples for Upload - Reduction and Data Scrambling
Try this expression for the search string:
='(' & concat(DISTINCT AGGR(IF(FirstSortedValue(
{<
ADMIT_DT ={">= $(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12))) <=$(=MAX(ISLAND_CALENDAR.DATE))"},
FLG_Z_PATIENTS = {0},
ISLAND_DEPT.DEPT_ABBR = P(DEPT_ABBR)
>}
DEPT_ABBR,-ADMIT_DTTM)= ISLAND_DEPT.DEPT_ABBR,MRN),MRN,ISLAND_DEPT.DEPT_ABBR),'|') & ')'
That was it, I was pretty close. Thank you very much.