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

[Gysbert_Wassenaar]

I don't understand your question. Do you want to change the Null symbol from a - character to a blank? Do you want to filter a straight table (or pivot table) object so only the rows where the date field has no value are displayed?

[danielnevitt]

Hi Gysbert,

Thank you for your reply.

I would like to filter a straight table object so only the rows where the date field has no value are displayed.

Regards,

Daniel

[ashfaq_haseeb]

May be like this.

Regards

ASHFAQ

[Gysbert_Wassenaar]

Ok, you can change the expressions in your straight table. For example sum(Sales) would become sum({$<MyDate -= {'*'} >}Sales). That should filter out any non-null value and leave only the nulls.

[danielnevitt]

Hi,

The above is returning no results.

Below is the code I used:

sum({$<fully_paid_dt -= {'*'} >}amount_due_in_pay_curr)

Are you able to advise what the issue might be?

Thanks,

Daniel

[ashfaq_haseeb]

Try like this

If not post sample application

sum({$<fully_paid_dt ={''}- {'*'} >}amount_due_in_pay_curr)

Regards

ASHFAQ

[Gysbert_Wassenaar]

Then perhaps your - values are not nulls but actual - characters. Try sum({$<fully_paid_dt = {'-'} >}amount_due_in_pay_curr)

[danielnevitt]

Hi,

Unfortunately the above do not work.

I have tried to use voucher_num instead of fully_paid_dt and I am still having the same issue.  voucher_num is an integer and appears as - in my data when the field is not populated.

I do really appreciate your help with this issue.

Regards,

Daniel

[Gysbert_Wassenaar]

Can you post a document that demonstrates the problem?