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

Question

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.

Thanks,

Syam.

2018-03-06-0255.png (39.4 kB)

Answer 1

Andrey Uryukin Answered 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

Comment

Find Questions & Answers