Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
=aggr(if([List Title] = 'Award', Date([Completed Date])), ID)