3 Replies Latest reply: Aug 9, 2017 1:49 AM by P M RSS

    restrict specific user data

    Agrim Sharma

      Hi,

       

      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

       

      Thanks,