Skip to Content
0
Former Member
Nov 12, 2012 at 05:46 AM

Count the number of inactive materials

53 Views

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