BAQ Dashboard

Kinetic ERP
,
1

I am looking at the field JobHead.TravelerLastPrinted and on the dashboard I want to filter it to show for some parts when there is no date and on some parts when there is a date. Is there a good way to filter for this?

2

@ypgpatel Make a calculated field with a case statement that sets a value you can then filter on.

3

case when JobHead.TravelerLastPrinted is null then 0 else JobHead.TravelerLastPrinted end

something like that? If the field is blank, it should put a 0, otherwise the date should popup. Would I be able to filter based on field or 0 in this case?

4

This is just the filtering field so the case would be null then 0 not null then 1