Calculation.
$180 - $1 = $179 but the site is showing $178.
I a, also trying to edit the fields in the
Review and submit
Please review your response before submitting it for processing.
But I cannot find it.
Hi Marcus, the formula that you have added for the Amount due field is NETTOTAL() - Less membership fee. That's why the calculated value for is incorrect. You just have to use NETTOTAL() as it will automatically subtract the discount from the order amount to calculate the net amount. Please make the following changes.
Update the formula for the "Total Amount" field
Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the Total Amount field to select it > click on the gear icon next to this field > Field settings page will be displayed > click Answer > delete the existing formula in the Calculate option, enter TOTAL() and click Save.
Update the validation for the "Less membership fee"
In the Neartail Edit page, click on the Less membership fee field to select it > click on the gear icon next to this field > Field settings page will be displayed > click Answer > update the response validation (select Number, Is Number) and click Save.
Update the formula for the "Amount Due" field
In the Neartail Edit page, click on the Amount Due field to select it > click on the gear icon next to this field > Field settings page will be displayed > click Answer > delete the existing formula in the Calculate option, enter NETTOTAL() and click Save.
Thank you for your support.
https://neartail.com/public/113480384778585944241/home/form/1FAIpQLSfqhP50n8Ez72SYSEeIfJeOvwrCvknyjMEk8V0EgRq0U9ufOQ/
There is a section with this.
Less membership fee: 123
I would like to change it to:
Less membership fee: -$123
so that it looks like this.
Total Amount: $800.00
Less membership fee: -$123
Amount Due: $677.00
If we want 'Less membership fee' to have a decimals like 123.30, how does the validation work?
Hi Marcus, We do not have the option to format the input answer.
If you use the ${response()} formula, it will show a summary of responses (question title, answer). The other option is to use the ${BILL()} formula to show a summary of the items with prices in the bill format (product name, quantity, unit price, amount).
Comments (4)
Apr 12, 2024
Here is the screenshot.
Apr 12, 2024
Hi Marcus, the formula that you have added for the Amount due field is NETTOTAL() - Less membership fee. That's why the calculated value for is incorrect. You just have to use NETTOTAL() as it will automatically subtract the discount from the order amount to calculate the net amount. Please make the following changes. Update the formula for the "Total Amount" field Login to Neartail > click on the form to open it > Edit page will be displayed > In the Neartail Edit page, click on the Total Amount field to select it > click on the gear icon next to this field > Field settings page will be displayed > click Answer > delete the existing formula in the Calculate option, enter TOTAL() and click Save. Update the validation for the "Less membership fee" In the Neartail Edit page, click on the Less membership fee field to select it > click on the gear icon next to this field > Field settings page will be displayed > click Answer > update the response validation (select Number, Is Number) and click Save. Update the formula for the "Amount Due" field In the Neartail Edit page, click on the Amount Due field to select it > click on the gear icon next to this field > Field settings page will be displayed > click Answer > delete the existing formula in the Calculate option, enter NETTOTAL() and click Save.
Apr 18, 2024
Thank you for your support. https://neartail.com/public/113480384778585944241/home/form/1FAIpQLSfqhP50n8Ez72SYSEeIfJeOvwrCvknyjMEk8V0EgRq0U9ufOQ/ There is a section with this. Less membership fee: 123 I would like to change it to: Less membership fee: -$123 so that it looks like this. Total Amount: $800.00 Less membership fee: -$123 Amount Due: $677.00 If we want 'Less membership fee' to have a decimals like 123.30, how does the validation work?
Apr 18, 2024
Hi Marcus, We do not have the option to format the input answer. If you use the ${response()} formula, it will show a summary of responses (question title, answer). The other option is to use the ${BILL()} formula to show a summary of the items with prices in the bill format (product name, quantity, unit price, amount).
Add your comment
Add photo