Calculated columns

[Daniel]

Hello team,

Currently, I have a requirement to add 3 calculated columns: SubTotal, Tax, and Total, those columns must be calculated when the user types in the cost or quantity column. SubTotal = cost * quantity. Tax =  SubTotal * 0.10 and Total =  SubTotal +  Tax. There is any way to achieve that in synfusion grid?

I really appreciate any help you can provide.

[Hemanthkumar S]

Hi Daniel,

Greetings from Syncfusion support.

Query: SubTotal, Tax, and Total, those columns must be calculated when the user types in the cost or quantity column

From your shared information we identified that you want to automatically update the column based on another column's edited value. We have already discussed the same in the below documentation which contains the code example. Please refer to the below documentation for more details.

Automatically update the column based on another column edited value: https://ej2.syncfusion.com/aspnetmvc/documentation/grid/editing/in-line-editing#automatically-update-the-column-based-on-another-column-edited-value

Please feel free to contact us if you require any further assistance. We are always available and eager to help you in any way we can.

Regards,

Hemanth Kumar S