Hi Guru's
I have calculation view, where primary date count equal to primary sale count.
I have added primary date into output section and changed the type into measure and aggregation into count.
But so many null values are coming according to customer.
I want to remove those null values . Please guide me.
2018-03-06-0255.png
Thanks,
Syam.
Why you do not just apply a filter on an existing or new underlying projection node to "remove" the records with null values?
Hi,
In order to remove nulls just filter out all records where CUST_NAME equal to null in filter.
I assume you have a projection node - then filter it out there.
Then, in aggregation node no null values will exist.
BR,
You already have an active moderator alert for this content.
Add comment