Teradata Error 3504

General

Teradata Error 3504

Hello,

I have an issue regarding a group by for my query: Error 3540

I understand what it means on a basic level and I believe the issue revolves around this particular column

CAST((COALESCE(price, 0.000000)) AS DECIMAL(18,6)) * quantity amount

if I put amount in the group by it says that it cannot group by with aggregates but if I take it out it outputs error 3504

Any help?
Tags (3)
1 REPLY
Enthusiast

Re: Teradata Error 3504

If you haven't already resolve this, post your query.