Skip to Content
0

Select Latest Record Based on Selection Variable

Feb 09, 2017 at 06:47 PM

47

avatar image

Hi all,

I need to find the number of Accounts moved from one Branch to another Branch and it should select the latest record based on the selection date variable. Please note that the Exception Aggregation on Account Number with 'Last Value' option can't be used since the 'Old Branch' is there in rows. How can I accomplish it in BEx, please? bex-query.jpg

Thanks,

Venkat.

bex-query.jpg (94.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Mar 01, 2017 at 09:32 AM
0

Hi,

I advise you to add changed to in your dataset, than you will be possible to achieve your goal, because than you will now if the record is still valid or not.

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded