Need count of items in query

[merlynsdad]

I have a query of all calls into a callsite. Those that were transferred from someplace show the number dialed; those that were dialed direct I have blanked the number (ending in 7650) with the expression

CallTrfdFrom: IIf(Right([calldata_b],4)<>"7650",Right([calldata_b],10))

I would like to count the instances of calls transferred so i can get a percentage, but I'm not sure how to do this.

If the square peg won't fit in the round hole, sand off the corners.

 

[PWise]

CountDrictDiled:sum(iif(Right([calldata_b],4)<>"7650",1,0))

also you have to add a group by

 

[merlynsdad]

It's telling me I can't have an aggregate function in a group by clause.

If the square peg won't fit in the round hole, sand off the corners.

 

[PWise]

group by IIf(Right([calldata_b],4)<>"7650",Right([calldata_b],10))