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

Question

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

Vipin · Accepted Answer

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.

Guesswork

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

Comments (1)

Add your comment

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

Comments (1)

Add your comment

Related questions