minimum value if

[stevenpiers]

Hi,

I'd like to display only the information from the same record. Example below are different packages/ dimensions.

VPNART: the key (ProductID)

VPACEH: QTY in box

VPVUIT: 1 = we can handle/  0 we can't handle

... rest are dimensions/ weight

min.value VPACEH where VPVUIT = 1

Example of what I want to display with an expression: 

VPNART	VPACEH	STREEP	VPVINS	VPVUIT	VPHVRP	VPBVRP	VPDVRP	VPGVRP
011330	1	-1	0	1	11	207	312	523
011331	5	-3	1	1	47	154	211	1152
011332	1	-1	0	1	9	104	141	116

INPUT

VPNART	VPACEH	STREEP	VPVINS	VPVUIT	VPHVRP	VPBVRP	VPDVRP	VPGVRP
011330	1	-1	0	1	11	207	312	523
011330	5	-3	1	1	54	215	319	2908
011330	20	-6	1	0	60	60	60	60
011330	1320	-9	1	1	1450	800	1200	0
011331	1	-1	0	0	11	149	208	231
011331	5	-3	1	1	47	154	211	1152
011332	1	-1	0	1	9	104	141	116
011332	10	-3	1	1	82	112	149	1173

Which expression displays the information I want...?

Many thanks for your help.

[Nicole-Smith · Accepted solution]

You can get it by using FirstSortedValue() like this:

FirstSortedValue({<VPVUIT={1}>}VPACEH,VPACEH)

Please see the attached example for a full solution.

[stevenpiers]

Just... perfect! Thanks Nicole!

[rupamjyotidas]

Maybe you can close the discussion