Ignore selection on blanks and text in expression

[dandaanilreddy]

Hello All,

I have below expression in which for some of the products i assigned blank space and for some i assigned text and the remaining products i have ignored a selection. When i select any value from the ignore selection field only the blank space and text products are effecting because i didn't ignored the selection. Please can someone let me know how can i ignore the selection on blank space and text for the products?

if(wildmatch(product,'Test1','test2', 'test3'),' ',

if(wildmatch(product',Test4'),'No Data',

sum({<date={'$(vMinP1)'},ID=>}value)

))

Thanks

[abhijitnalekar]

Hello @dandaanilreddy ,

Try 

if(wildmatch(product,'Test1','test2', 'test3'),' ',

if(wildmatch(product',Test4'),'No Data',

sum({<date={'$(vMinP1)'},ID=,product=>}value)

))

[dandaanilreddy]

Hi Abhijit,

Thanks for the response. I still see the selection is effecting with the above expression. When i select a ID those blank and no data are showing as zero.