Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning community
facing a problem
this are my two filed
this are my codes used for max date and clm_no
max date :
=MaxString(aggr(MaxString(if(len(KeepChar(CLM_XGEN_CLAIM_NUM,'-'))<>3,CLM_INTIMATION_DATE)),HOSPITAL_CODE,HOSPITAL_NAME,CLM_INTIMATION_DATE,ICD_CODE_LEVEL1_org))
and for clm_no is :
=MaxString(aggr(MaxString(if(len(KeepChar(CLM_XGEN_CLAIM_NUM,'-'))<>3,CLM_XGEN_CLAIM_NUM)),HOSPITAL_CODE,HOSPITAL_NAME,CLM_INTIMATION_DATE,ICD_CODE_LEVEL1_org))
but its not showing me right output
max date is coming but its not showings clm no
i want when max date comes then its associate clm_no should come
output should be
can any one help me in this
THIS IS MY TABLE
