topic Re: Ignore selection on blanks and text in expression in App Development

Ignore selection on blanks and text in expression

dandaanilreddy — Thu, 30 Sep 2021 12:08:48 GMT

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

Re: Ignore selection on blanks and text in expression

abhijitnalekar — Thu, 30 Sep 2021 12:30:39 GMT

Hello @dandaanilreddy ,

Try

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

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

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

))

Re: Ignore selection on blanks and text in expression

dandaanilreddy — Thu, 30 Sep 2021 13:00:34 GMT

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.