Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Could anybody help my with that mistake in the Sum-Formula? Is the Statement to Group by OverallTransactionDate correct for an aggregration of the sum?
Many thanks in advance.
Carolin
May be try different ways
Load
OveralTransactionDate,
Sum( If(OrderPhase_Desc = 'Revenue' , NettAmountUSD)) as SalesNettAmountUSD
From Location
Group By OverallTransactionDate;
Sorry i forget to add the Group by line
Regards
Anand
I Believe SET analysis not worked in the load script.
Regards
Anand
May be try different ways
Load
OveralTransactionDate,
Sum( If(OrderPhase_Desc = 'Revenue' , NettAmountUSD)) as SalesNettAmountUSD
From Location
Group By OverallTransactionDate;
Sorry i forget to add the Group by line
Regards
Anand
Load
OverallTransactionDate,
sum(NettAmountUSD) as SalesNettAmountUSD
From
Where OrderPhase_Desc = 'Revenue'
Group by OverallTransactionDate
Many thanks for your quick help!!