Skip to Content
0
Jul 23, 2023 at 06:28 PM

Creating a New Field with Quantity-Based Calculations in Custom CDS View using Calculations

104 Views

Dear Experts,

I am currently working with a Custom CDS APP where I am consuming the view I_MfgOrderWithStatus. As per the requirements, I need to create a new field in the Custom CDS View using the following formula:

NewField = ((I_MfgOrderWithStatus.ActualDeliveredQuantity / I_MfgOrderWithStatus.MfgOrderPlannedTotalQty) * 100) - 100

Unfortunately, I encountered an error while trying to implement this calculation:

"Amounts and quantities are not allowed in expression - SD_EXPRESSION/095"

Is there anyway to achieve the result?

Thank you in advance!