How to delete the Rows which are not required

[SanchitArora]

Hi, If i have 3 columns like material, quantity and week. Now I have to create a new column in which i do not require the data for which quantity is not available. How to to that? Kindly let me know . Also as i am not using coding so i would appreciate if you can help me in creating this in advance expression in the commutated columns of query builder.

Thanks

Sanchit

[Reeza]

I think you need to explain a bit more. If you actually want to remove these rows then it's easiest to add a filter which would be a WHERE clause, otherwise you can try with a CASE function. The CASE function will not delete rows.

Case when quantity ne . then 0

when quantity eq . then .

end

[SanchitArora]

Hey thanks a lot...filter make it working which i needed..