Include Null on dimension returns two results per line

[Evan0211]

I am not sure what I am doing wrong. I have a dimension that does the following:

=if([List Title] = 'Award', Date([Completed Date]))

When I include null values, the table includes the date and a - for every line that has a date. Why is it showing a null line and a date line for the same data item?

I need to show null values because there are some IDs that haven't been Awarded yet, so I need to capture those, I just can't figure out why it is generated two rows for each record, one with a date and one with a null -

The first column is the ID of the data item and the second column is the Completed Date of the Award

[Chanty4u]

Try this

=aggr(if([List Title] = 'Award', Date([Completed Date])), ID)