This content has been marked as final. Show 3 replies
i have some "party_name" its "basicvalue" and "market"
i dont want to include "party_name" starting from 'ALEX*' and i want to have only DOMESTIC market sales
So, I applied this formula but its wrong,
sum(if( "market"='DOMESTIC', if( party_name <> 'ALEX *' , (basicvalue))))
can you make it correct please