Set Analysis

risabhroy_03 · ‎2021-12-20

I have 3 fields below Company Code, NumDate, Weight.

Each company code has multiple dates stored.

I want to sum my Weight on the basis of the Maximum Numdate for each company code.

Example - For company code 215, my weight should be on the basis of the maximum NumDate that is 15-12-21.

For Company code 220, my weight should be on the basis of the maximum NumDate that is 17-12-21.

Can anyone help me achieve this?

anat · ‎2021-12-20

have u tried below link

risabhroy_03 · ‎2021-12-21

Can i use it without if.

I want to do it with only set analysis.

Related Topics