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.