To show only null records in straight table

[sunitha_chellaiah]

Hi All,

I  want to show only null records in straight table for the column Agreed delivery date.

I am using below mentioned expression in measure.

=IF(IF(InList=1,(MAX({<[SDLNTY - Line Type]={'S'}>}[SDURDT - Date - Agreed Delivery])-MIN({<[SDLNTY - Line Type]={'S'}>}[SDURDT - Date - Agreed Delivery])),0)>0,'Multiple Dates')

PFA.

[tresesco]

You may try using the reverse condition in IF, like:

If( <expression>   <=0, '-')             // or, you can use null() instead of '-' depending upon effect of the default suppress nuisance   

[sunitha_chellaiah]

How do I remove that 'Multiple Dates' records from the table. I need to remove that whole rows.

[tresesco]

Could you share your sample app?