Delete lines without any value

[enginimaldb]

Hi,

in a query i have lines without any values. How can i delete this lines from the query view?

Thanks

[former_member189638 · Accepted solution]

Do you want to restrict the records with Key Figure value as blank?? Then first hide your key figure and create a calculated key fgure as CKF = KF + 0. This will change the blank to 0.

Now you can create a condition in a query. Create the condition for CKF using the Operator Greater Than and value 0. This will filter out all the records having the key figure value as blank.

[shanthi_bhaskar]

check this

http://help.sap.com/saphelp_nw04s/helpdata/en/a4/dd3841d132d92be10000000a1550b0/content.htm

[sven_mader2]

in the query properties you see "Suppress Zeros". Set it to "Active".

Sven