workaround for nested aggregation

[macdonaldm]

Hello! I am trying to create a field/column that will label a customer as "Existing customer" if the number of sales is greater than 1, and "New Customer" if the # is <=1. I created a function listed below. 

if(Count([Sale Amount]>1, 'Existing Customer', if(Count([Sale Amount]<=1, 'New Customer'))))

But it says "Nested aggregation not allowed". What is the right way to create this? 

I also tried to add field in data manager, but there is no count or sum options. Either way is fine!

[Channa · Accepted solution]

if(Count([Sale Amount])>1, 'Existing Customer', 'New Customer')

try

[macdonaldm]

Thank you!