Error on writing if condition to filter multiple fields using "and" operator in script

[Anonymous]

Example:

if(country='A'  and state='B' and city='C' , sum(sales)/ count(city='C'), sum(sales))

Thanks in advance.

[Chanty4u]

its working for me

[sunny_talwar]

Are you using this in the script? I don't see anything wrong with the if statement, but if you are using this in the script, you might need a group by statement in your table load. May be provide more information to help you better

[Anonymous]

yes i am using this in the script , tried using group by too. correct me if i am wrong in writing the statement.

Example:

if(country='A'  and state='B' and city='C' , sum(sales)/ count(city='C'), sum(sales)) as A sales

resident table

group by Country;

[Anonymous]

yeah its working for me too in the front end but not in the script.

[sunny_talwar · Accepted solution]

Not sure what all dimensions you have, but you at least need country, state and city because they are not aggregated

if(country='A'  and state='B' and city='C' , sum(sales)/ count(city='C'), sum(sales)) as A sales

resident table

group by Country, state, city;

[Anonymous]

Thanks a lot sunny, its working now with group by Country, state, city.