Hello,

I have been trying to configure a dashboard that calculates total cost of multiple projects inputted via Survey123. Projects are broken down in multiple categories. I can get each category to provide a sum for that category, however I cannot figure out how to display the total cost. I have tried putting a calculation field, but I don't think the formula is correct.

Here is a portion of the dashboard:

How would I configure a widget to give me the sum of category c, d and g?

I don't think there's a way to do calculations within Operations Dashboard. There are a couple ideas related to this:

Arcade Expressions in Operation Dashboard

Arcade Expression in Ops Dashboard List Widget

You could calculate the value within Survey123. If you're just looking to sum three values, the formula you want would be something like this:

${cat_c_project_cost} + ${cat_d_project_cost} + ${cat_g_project_cost}

The sum() function is used to calculate the sum of the responses to a question that uses repeats.