Skip to Content
-1

How to count not null values for date field in Calculation view ?

Mar 06 at 07:58 AM

47

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

Why you do not just apply a filter on an existing or new underlying projection node to "remove" the records with null values?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Andrey Uryukin Mar 11 at 02:19 PM
0

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,

Share
10 |10000 characters needed characters left characters exceeded