Can anybody help with this problem. I'm trying sp group customer into 3 categories based on revenue. i've made the following statement which works fine in expression, but won't work as a calculated dimension.
=If(Sum(if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA', New_NET)) >= '90000', 'A',
if(Sum(if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA', New_NET)) >= '30000' And Sum(if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA', New_NET)) < '90000', 'B',
if(Sum(if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA', New_NET)) < '30000', 'C', 0)))
I've come to the conclusion that it is the dual condition in line 2 and 3 there are causing the problem (Its a normal "and" sentence like in Excell). does anybody know how to get around this without editing the script ?
