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

    restrict specific user data

    Agrim Sharma



      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