Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you share a sample data ?
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'))
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.