Double date

sagarrahul · ‎2016-08-02

hiii

my table

this is my code for getting clm_no :

=FirstSortedValue(CLM_XGEN_CLAIM_NUM,-aggr(Max(if(len(KeepChar(CLM_XGEN_CLAIM_NUM,'-'))<>3,(CLM_INTIMATION_DATE))),

POL_BDM_CODE,POL_BDM_NAME,HOSPITAL_CODE,HOSPITAL_NAME,CLM_INTIMATION_DATE,CLM_XGEN_CLAIM_NUM,ICD_CODE_LEVEL1_org))

in this second coulmn last field is coming blank

in this i want max date with its clm_no but max_date is coming but clm_no is not coming

there are there 3 time same max_date and same 3 time same clm_no in this table

so i want this output in table :

so pls help me in this its on urgent basics

Related Topics