Skip to Content
0

issue related to Bex query

Oct 07, 2017 at 12:12 PM

61

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Oct 11, 2017 at 01:02 PM
0

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
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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

0