Skip to Content
0
Aug 07, 2023 at 10:51 AM

How to do Calculations in CDS View While creating Reports on SAP S4 HANA Cloud?

162 Views Last edit Aug 09, 2023 at 06:26 AM 2 rev

Hi All, Hope you are doing great.

I am Creating Reports by using CDS View on SAP S4 HANA Public Cloud. I wanted to create Credit Exposure Report, Standard one is available but My client wants 3 more columns that is Open Order amount, Account balance amount and Exposure Times. For that I have added Total Receivables as a associated Data Source Now I wanted to Subtract element Total Overdue from element Total amount to get Account balance Tab , but I am facing multiple errors. For Exposure Times Tab also I have to divide element credit limit amount with element Exposure amount to get the data but for that also I am facing error. I am adding calculation , selecting functions and applying Division and Subtraction formula but still getting errors.

Please advise how can I successfully apply Formula in Calculations for my CDS View Report on S4 HANA Cloud.

Your Help is valuable, Thanks in Advance.