Custom Forms/ automatically generated two fields together.

[jessicaramirez]

I am creating a custom form with one field as total in-store sales and another field as total online sales. I need to create a field (total sales) that will automatically generate the sum of those two fields ( in-store + online). What would the backend calculation logic look like? 

[_Manish_Singh · Accepted solution]

Hi there! To calculate the total sales, you can use the following formula:
SUM({DE:Total In-Store Sales},{DE:Total Online Sales})

Please remember that custom fields should be prefixed with "DE:". Also, make sure to replace "Total In-Store Sales" and "Total Online Sales" in the formula with your actual field values.

Make sure you choose the correct format: