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?
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.