Remove Blank records from BEx Query

[sanjay_gajera]

Dear All,

Please have a look at below attached screen shot , where i want to remove the rows entries where the no. of rows count is blank. I dont want to show those dates in the Query result where the count is blank.

I have tried with Query property -> Rows/Cols -> Supression with Zero , but it is not working.

Please do the needful as soon as possible.

Regards,
Sanjay Gajera

+91 89050 74894

[Loed]

Hi,

Bhavin's suggestion is correct.

Just click the name of your structure and uncheck the "Structure as group. Only apply Suppression when all elements are zero" under the DISPLAY tab.

Regards,

Loed

[sanjay_gajera]

Thanks Both for the solution.

[Loed]

Hi Sanjay,

You are very welcome. You may now close this thread.

Regards,

Loed

[kohesco]

Hi,

you can set also a condition on the number of records as a solution.

Grtz

Koen

[bhavinvyas]

Try this,

Click on the Key-figures structure

Go to the display tab

uncheck "Structure as group. Only apply Suppression when all elements are zero"

Thanks,

Bhavin Vyas