calculated values work on Dev and Local client but fail to work on QA
I created some calculated fields in the Quote Header (BC: Quote) These fields show fine in my Development environment and local development client, but when I deployed in QA these do not work
In Quote BC i have the following MVL fields:
Field: Total DM %
Calculated Value: IIF(([Total DM (Broken Cost)] IS NULL or [Total DM (Broken Cost)] = 0),'', (([Total DM (Broken Cost)] - [Total DM (Standard Cost)])/[Total DM (Broken Cost)]) * 100)
Field: AA $ Value
calculated Value: Sum([Quote Item AA Value Projection])
Field: Total Quote Margin
calculated Value: IIF(([Total DM Broken Cost No Exclude] IS NULL or [Total DM Broken Cost No Exclude] = 0), "", (([Total DM Broken Cost No Exclude] - [Total DM Standard Cost No Exclude])/[Total DM Broken Cost No Exclude]) * 100)