if nest

[davinfrost]

hi guys, i wanted to count sales but i have a prob

i used this one

sum(aggr(if(len(trim($(Sales)))>'0','1','0',if(not[Item Name]like '*BONUS*','0','0'))

and that bcd item still counted

thanks

[Taoufiq_Zarra]

@davinfrost 

can you share a sample data ?

[Chanty4u]

Not sure try this. if not share the sample data

sum(aggr(if(len(trim($(Sales)))>'0','1','0',if(not WildMatch[Item Name] '*BONUS*','0','0'))

[Dalton_Ruer]

Sum(Sales) will return the value of the Sales column. The field with Bonus has a 0 value in your example. Not sure you need to make it so complicated.