I am trying to add two fields of one CDS view in other CDS view. I am getting Zero as the output if any of the operand is Zero.
In the first CDS I am getting the SUM of sum field as
@DefaultAggregation: #SUM sum( total.tmp_count ) as total, @DefaultAggregation: #SUM sum( blank.tmp_count ) as blank, @DefaultAggregation: #SUM sum( error.tmp_count ) as error
and in the second CDS I am adding the fields Total and error as
total, error, total + error as Total_error
and the output is
so if any of the operand (either error/total) is zero my output (Total_error) is coming as Zero.
I tried the below cases also
all these cases i am getting the same output.
Any input will be highly appreciated.