Trigger - show only null values for a date field

[danielnevitt]

Hi,

I have a field (fully_paid_dt) and I want to create a sheet trigger to only show where the field is blank.  Currently the field displays a - if there is no date populated.

Any help with the above will be much appreciated.

Regards,

Daniel

[danielnevitt]

Hi,

I have attached a file.

If you could show me how to create a table where:

1) voucher_num equals -

2) voucher_num not equal to -

Thanks,

Daniel

[ashfaq_haseeb]

Like this.

Have a look at attached application

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

1) voucher_num equals -

=sum(extended_amt)-sum({$<voucher_num ={'*'} >}extended_amt)

2) voucher_num not equal to -

sum({$<voucher_num ={'*'} >}extended_amt)

Regards

ASHFAQ

[danielnevitt · Accepted solution]

Thank you both for your help.

I decided to SET NullDisplay='-' to simplify the selections (as I have Null values on several different fields).  I then used the original code you both provided.

Regards,

Daniel

[ashfaq_haseeb]

Glad To know

Regards

ASHFAQ