Neha Yadav

Compare two values at different posting date in BEx

Posted on Jul 31, 2020 at 08:54 AM 30 Views

Hello

I have a scenario where in BW ADSO I have records at below granularity. I want to compare AMT data with value 1 in Item number column v/s AMT data with value 2 in Item number which has the latest Posting date. If the AM is same then I want to print AMT column else nothing.

In below example I want to compare the first row Amount and third row amount and since the value is same , I want to print data. I want to implement this scenario in BEx. is it possible to do ? I have written a formula but it is not working as expected

"[AMT] GR" = "[AMT] PO" * "[AMT] GR" . It compares posting date as well and since posting date is not same it doesn't print anything. Can anyone please suggest how to implement this in BEx query.

Regards

Neha

data-set.png (6.5 kB)

data-set.png (6.3 kB)

Add a comment

0 Answers

Sort by:

Votes

Newest

Oldest

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.

Rules of Engagement

Know someone who can answer? Share a link to this question.

Attachments: Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.