Skip to Content
avatar image
Former Member

issue related to Bex query

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 ..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 11, 2017 at 01:02 PM

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