Hello Experts,
I need to count the number of inactive materials, which are stored in a DSO. Active material being stored as 1 and inactive is zero. Now I need a count of Zeroes. Can anyone help me achieving this in Query Designer?
Material Isactive
ABC 1
BCD 0
CDE 1
DEF 0
EFG 1
Total count I need is 2 since there are two inactive materials.
This should be easy one but am no expert in Query designer.
Thanks
Shrirama