Nested Aggregation Error

[#1]

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

[#2 · Accepted solution]

Guys,

I have figured it out.

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

Sorry for bothering you guys