Enable Calculation Columns for Custom Attributes in Change Orders

[vanessa.budi]

We would like to request to add calculation column functionality for custom attributes in change orders to automate calculations.  

Custom calculation columns are currently not available for change orders. While custom attributes can be used with manual input, there is no way to create calculated fields that automatically compute values based on these custom attributes.  

Therefore, we would like to add the ability to create calculation columns in change orders that can reference and perform mathematical operations on custom attributes, similar to how calculation columns work in other ACC modules (Budget Overview Columns) 

This additional feature will eliminate manual calculation errors, reduce spent on repetitive calculations, improve data consistency across change orders and enable real-time updates when attributes value change. 

Example: 

Based on the screenshot above, 

Custom Attribute 1: RAOV (Add) S$ 

Custom Attribute 2: RAOV (Omit) S$ 

Desired Calculation Column: "RAOV (Nett)" = [RAOV (Add) S$] + [RAOV (Omit) S$]

Current workaround issue of now is manual calculations in custom attributes which is prone to human error, inconsistent updates when source values change, time-intensive data entry and difficulty in maintaining accuracy across multiple change orders. So, it will be better if formula builder interface similar to the "Budget Overview Columns" is applicable to Change Orders as well. Thus, it will allow real-time calculation updates when referenced attributes change.

It is also good to have a support for basic mathematical operations (+,-,/,x) and to format results in currency, percentage or decimal places). 

This new feature would significantly improve change order management efficiency and data accuracy for our project team. 

Thank you.