Skip to Content
avatar image
Former Member

Subtraction not working in CDS View

Hi,

I'm doing simple subtraction but not giving the expected result, below is the snippet and output.

I also try using CAST but it also didn't work. Need yours suggestion on this.

Regards,

Binay Biswakarma

Untitled.png (43.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 14, 2016 at 07:54 AM

    Are you sure that "open.menge" is not a null value?

    On the ABAP side, null values are mapped to INITIAL values which is 0 for numeric types.

    But in SQL the difference 1500 - NULL results in NULL.

    Regards, Thomas

    Add comment
    10|10000 characters needed characters exceeded