Skip to Content
avatar image
-1
Former Member

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

Mar 06 at 07:58 AM | 51 Views

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.

2018-03-06-0255.png (39.4 kB)
SAP HANA
SAP HANA studio
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Andrey Uryukin
    Mar 11 at 02:19 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded