Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
CAUSEDESCRIPTION | CLAIMNO |
Insured 1 | 177 |
Insured 2 | 177 |
Insured 3 | 177 |
Insured 4 | 78 |
Insured 5 | 45 |
How to display Insured1,insured2,insured3 in a text box.
Getting blanks for me after using below expression.
=fisrtsortedvalue(CAUSEDESCRIPTION,-aggr(sum(CLAIMNO),CAUSEDESCRIPTION))
Hi @venkat1
Try like below
Create a variable "vTopInsurance" and assign the formula like below
=Concat(DISTINCT CAUSEDESCRIPTION, '|',-Aggr(Sum(CLAIMNO),CAUSEDESCRIPTION))
and use the below expression in textbox
TextBox1: =SubField(vTopInsurance,'|',1)
TextBox2:=SubField(vTopInsurance,'|',2)
TextBox3:=SubField(vTopInsurance,'|',3)