Report type: Score, aggregation: sum, value formatting

[mikereaves]

My client creates dashboards with many widgets containing reports of type score to summarize financial values like total planned cost over a large set of projects.  
The summaries are in the millions of dollars and show cents (example: $20,945,325.89).
When presented to the "C" suite of executives, their first question is: "can you get rid of the .89?".

I would think this is a case for value formatting but OOTB, the report type: score with an aggregation of sum doesn't have any value formatting options.  This is puzzling because the aggregation: count allows value formatting..  you can specify a number of decimal places - or no decimal places. 

Counts by definition can only be whole numbers, they will never contain any digits past the decimal. 

Am I missing something?  My work around is Performance Analytics but it would be so much easier of reports of type: 'Score' would support value formatting.   

[gracjan]

@mikereaves 

Here is a workaround option:
Use a Formula Field to Round the Value
Create a new field on your table (e.g., u_rounded_cost) and populate it using a Business Rule or Glide formula:

current.u_rounded_cost = Math.round(current.planned_cost);

Then, use this field in your Score report instead of the raw planned_cost. This effectively removes the cents.

/ If this didn’t summon a rogue script include or awaken the ghost of deprecated APIs 👻 — consider it mildly useful and ceremonially tap Helpful 🪄 /