Nested Aggregation Error

Tue, 17 Feb 2015 05:22:02 GMT

Hi Friends,

I am trying to load a certain piece of code but getting a nested aggregation not allowed error. Can someone help me out?

All:

Noconcatenate Load

	'All' as STANDARD_PARTNER_REGION1,
	sum([INV On Hand Quantity])/sum(REVENUE_INV) as [INV On Hand Quantity1],
	sum([INV List Price])/sum(REVENUE_INV) as [INV List Price1],

Resident Fill_Rate_INV;

Thanks in advance

Rishikesh

Re: Nested Aggregation Error

Tue, 17 Feb 2015 06:54:31 GMT

Guys,

I have figured it out.

There was an extra ')', so i was getting the error.

Sorry for bothering you guys