expression issue

[buzzy996]

Hi Community,

This is scenario,any help pls...

CASE1:

ID   Priority  Numofdays  versionid

101  nu           0              14

101  nu           1              15

101  nu           3              16

Conditions: 1.priority='nu' and numof days={0,1} and

EXPECTED OUTPUT : 1 record  (this records should be in this case versionid=15,

                     but we cann't pass versionid as 15 in the expression,

                     why because this version id will change,

                     accordingly the above conditions we should consider max versionid)

CASE2:

ID   Priority  Numofdays  versionid

101  nu           0               4

102  nu           1               1

103  nu           5               8     

EXPECTED OUTPUT : 2 records (this records should be in this case versionid=4 and 1)

the above output expecting in chart only.

Thx in advance.