Using Conditions with Structures in Bex query designer

[Former Member]

Hi ,

We are using a query which has two structures. One for Key figure and other for Characteristic. At this point the report output looks like, as below

Actual Forecast Index

Customer

ABC 80 90 4

EFG 20 4.5

XYZ 10 6 5

LMN 15.5 5

As per the requirement, We have to Remove data for those customers for which value there is no forecast. I am trying to apply condition for this, but that is not working.

Is there something different when we apply conditions with structures in Bex? Kindly help

[Former Member]

go to the properties for the query and x out rows and columns for zeros..

[Former Member]

Hi ,

If your forecast is a key figure , then just make a condition on that keyfigure and give forecast NE 0 in that condition ,

Make sure that the condition is active .

Kind Regards,

Ashutosh Singh

[Former Member]

Hi,

I tried that, but still it is not working. The row is very much there.