Choose particular item in table

[berryandcherry6]

HI,

i have a simple table where a 'Fruits Name' column contains

Fruits Name

----------------

Orange

Banana

Grapes

Apple

here i need it to show all fruits except Banana and Grapes.

How could i do this.

[Chanty4u]

try this

fr:

LOAD * INLINE [

    fruits,

    Orange

    Banana

    Grapes

    Apple

];

new:

LOAD Fruits

Where not Exists ='Banana'and 'Apple';

[jonathandienst]

Are you looking for a front end expression:

=Sum({<fruits -= {'Banana', 'Grapes'}>} Amount)

[Chanty4u]

r try this

fr:

LOAD * INLINE [

    fruits,

    Orange

    Banana

    Grapes

    Apple

];

new:

LOAD fruits

Where not Match(fruits,'Banana'and 'Apple')  ;

[berryandcherry6]

Hi,

Thanks for reply

yes, i am using front end code.

i am using below condition,here how could i apply given logic.So that it shows all campaign except those two.

if(GetSelectedCount(select choice)>0,Fruits Name)

[#6]

Hi supriya,

Try this i hope it will work

For script end you use where not match([Fruits name],'Banana','Grapes');

Else

In front end you can use this below expression

=sum({<fruits =e($(=fruits={'Banana,'Grapes'}))>} Amount)