issue related to Bex query

[rizwana_khan1]

Dear all,

I have a scenario where I have data like this

sales doc item created date order receipt amount

100 1 10/07/2017 0 100

And in my case if createdon date is this month and order recipt is 0 then I should exclude this line item from the report output.

If Createdon date is not current month then I need this line item in report output

Please suggest ..

[kohesco]

Hi

solution 1 -> add an infoobject in your dataflow with the logic you want and you can easily filter the report via global variable on it in bex (best performancy)

solution 2 -> add formula:

(date <> this month)+(item <>0)

and set condiont on formula > 0

[rizwana_khan1]

Hi Koen,

In case if we follow company specific calander in that case how to get this month in Bex formula.

please suggest.

Thank you

[kohesco]

you mean fiscal period (use the correct fiscal variant as well)