Count

[#1]

hi there,

can you please put this in a statement for me

1 - Count - if Core<4 and hardware=new and Server=Wintel

2 - SUM - if Core<4 and hardware=new and Server=Wintel

[jpapador · Accepted solution]

Count(If(Core < 4 and hardware = 'new' and Server = 'Wintel', NameofFieldYou wantToCount))

Sum(If(Core < 4 and hardware = 'new' and Server = 'Wintel', NameofFieldYou wantToSum))