Sum & Aggregation

[carolin01]

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

[its_anandrjs]

I Believe SET analysis not worked in the load script.

Regards

Anand

[its_anandrjs · Accepted solution]

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

[Anonymous]

Load

     OverallTransactionDate,

     sum(NettAmountUSD) as SalesNettAmountUSD

From

(qvd)

Where OrderPhase_Desc = 'Revenue'

Group by OverallTransactionDate

[carolin01]

Many thanks for your quick help!!