Community

There are five categories of goods: A, B, C, D, and E. How can I set the quantity and amount subtotal for each category?

Anna

Jun 2

Comments (1)

Vipin

Jun 2

Calculate order quantity for a specific category If you have created a separate page with the title “Desserts” and added different product items, then you can use the QUANTITYIN function to calculate the order quantity for that category. Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the + Add field icon > enter the title (for example, Desserts Order Quantity), select the Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the QUANTITYIN(“Desserts”) formula in the Calculate option and click Save. Calculate order amount for a specific category Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the + Add field icon > enter the title (for example, Desserts Order Amount), select the Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the TOTALIN(“Desserts”) formula in the Calculate option and click Save. Note: The title you add in the formula must exactly match the title of the category page. It is case-sensitive.

Add your comment