🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

I need my summary to only display blank information from a Date field as a count measure.

User: "Michael Litterello"
Altair Community Member
Updated by Michael Litterello

I have a report where I need to investigate whenever we have blank information that appears in a date field.

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "CPorthouse"
    Altair Employee
    Updated by CPorthouse

    I would suggest creating a filter that would only display rows where the date field is blank or null and then using that filter in your summary.

    If you are using Data Prep Studio, you can create the named filter from the Analyze tab.  In Monarch Classic, you can create the filter from the Table Design interface.  Once the filter is created, make sure you choose that filter in your summary or export.