Skip to Content

Select Latest Record Based on Selection Variable

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 01, 2017 at 09:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded