Subtraction not working in CDS View

[Former Member]

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

[thomasgauweiler]

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

[Mujeeb]

Hello Binay, 

Quick solution to this problem is to use COALESC(menge,0). this function will result the 0 value in case of initial SQL value and your substractions will work as expected.

Regards

Mujeeb