2 Replies Latest reply on Jan 23, 2019 5:35 PM by Shinichiro Murakami

    Cannot mix aggregate and non-aggregate comparison...

    Haan Haan

      The message above shown when i inserted the calculated field below:

      Case [Select period]

      when 'MTD'  then if [order date] >=DATETRUNC ('month', [latest date]) and [order date ]<= [latest date] then countd ([client name]) end

      when 'YTD'  then if [order date] >=DATETRUNC ('year', [latest date]) and [order date ]<= [latest date] then countd ([client name]) end

      end

       

      I think the problem is on the COUNTD....may I know how to solve this?

      Thanks.