Skip to Content

Compare two values at different posting date in BEx

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

Related questions

0 Answers

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.
You must be Logged in to submit an answer.

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