formula to show the completed number of tasks of a project divided by the total number of tasks for that project

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you are trying to calculate the percentage of completed tasks for a project. You can achieve this by creating a formula that divides the number of completed tasks by the total number of tasks for a project. Here is a pseudo code example of how you might achieve this:

SUM({completed_tasks}) / COUNT({total_tasks})

In this formula,

{completed_tasks}

represents the field that holds the number of completed tasks for a project, and

{total_tasks}

represents the field that holds the total number of tasks for a project. Please replace

{completed_tasks}

and

{total_tasks}

with the actual field identifiers in your NetSuite environment. The

SUM

function is used to total up the number of completed tasks, and the

COUNT

function is used to get the total number of tasks. The result of this division will give you the percentage of completed tasks for a project. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******