selection on name

[prma7799]

Hi All,

I have one question that I want only one name when I select serial number .....9221 then it will show me only B.U bhandari name and order number .....0344

PFA

Thanks

Prashant

[prma7799 · Accepted solution]

Hi Kamiel,

Date

=Aggr(FirstSortedValue(Date(Floor(Date(BL_DT_VPC)),'DD/MM/YYYY'), -BL_DT_VPC),SERIAL_NUM_VPC)

is ok but I want only one record for order number .....0344 but I got solution

=if(aggr(max(BL_DT_VPC),ORDER_NUM),date(aggr(max(BL_DT_VPC),SERIAL_NUM_VPC)), date(BL_DT_VPC,'DD/MM/YYYY'))

Thanks

Prashant

[kamielrajaram]

Hi,Glad to have helped.

Kamiel