Skip to Content
0
Mar 22, 2018 at 09:01 AM

CDS Subtraction inconsistency

751 Views

Hi Experts

I have written cds view for budget report using BPJA & COSP tables.

So far everything is working as expected until last step where I encounter a weird behavior which I don't understand.

Final formula I am using to calculate the available budget is as below :

Budget(BPJA value) - Spend(COSP) = Available.

  • 100.00 - 0.00 = 0. 00 This is the issue, instead is should be 100.00 in Available
  • 100.00 - 20.00 = 80.00 This is working fine

Please point me to possible cause of this issue.