correct this formula SUM({completed_tasks}) / COUN...
# ask-stanley-ai
n
correct this formula SUM({completed_tasks}) / COUNT({total_tasks}) the error is ERROR: Field 'completed_tasks' Not Found
c
AI generated answer (using internal Slack threads):
The error message "ERROR: Field 'completed_tasks' Not Found" indicates that the field 'completed_tasks' does not exist or is not accessible in the current context. You need to ensure that the field 'completed_tasks' is available and correctly spelled in your formula. If 'completed_tasks' is a custom field, it should be referenced as
{custrecord_completed_tasks}
or whatever the script id of the field is. If 'completed_tasks' is a standard field, please ensure that it is correctly spelled and is available in the context where you are using the formula. If 'completed_tasks' is a summary field in a saved search, you might need to use a different function to aggregate it, like
SUM({custrecord_completed_tasks})
. Please note that the field names are case sensitive in NetSuite, so ensure that the field name is correctly spelled with the right case. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836113691
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828048229
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821983874
Please provide your feedback on this answer.