Does anyone know how/if to do the following in a BAQ?
select
ABCCode.CountFreq,
COUNT(ABCCode.countfreq) as NumOcurr
from ERP.ABCCode
group by (ABCCode.CountFreq)
When I try recreating it in a BAQ I can an error;
Severity: Error, Table: , Field: , RowID: , Text: Column ‘Erp.ABCCode.CountFreq’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Not quite the same thing. Trying to count the number of occurrences of the some countfreq. ABCCode is silly example, but I was trying to make it simple.
So I have 2 ABCCodes that have 33 as the countfreq.