Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can get it by using FirstSortedValue() like this:
FirstSortedValue({<VPVUIT={1}>}VPACEH,VPACEH)
Please see the attached example for a full solution.
You can get it by using FirstSortedValue() like this:
FirstSortedValue({<VPVUIT={1}>}VPACEH,VPACEH)
Please see the attached example for a full solution.
Just... perfect! Thanks Nicole!
Maybe you can close the discussion