- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-12-2025 03:45 AM
Hello I have a requirement to show the sum of the total contract value from the ast_contract table using PA and display it in dashboard,
Can it be achieved please suggest the steps
Thanks
Solved! Go to Solution.
- Labels:
-
Performance Analytics

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-12-2025 03:52 AM
- Navigate to Data Visualizations
- Create a single score type of widget on ast_contract table
- Change the metric to 'Sum' from 'Count' and choose the field whose sum you want to calculate.
Check the below screenshot example where i set the sum of 'Total Cost' field.
Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-12-2025 03:52 AM
- Navigate to Data Visualizations
- Create a single score type of widget on ast_contract table
- Change the metric to 'Sum' from 'Count' and choose the field whose sum you want to calculate.
Check the below screenshot example where i set the sum of 'Total Cost' field.
Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-12-2025 04:15 AM
Ok that is one way in the ui builder but can we create a pa indicator and then display it

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-12-2025 05:02 AM
where do you want to display? In a dashboard?
If yes, you can still do it with this. you can place this anywhere in any dashboard or you can share the direct link to this also.
Let me know if you need further help.
Regards,
Sumanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-12-2025 05:04 AM
In workspace actually