If you are using a Free Form column for currency values and find that Streak is not calculating all of the money listed in the column, it could be because your numbers are input in different formats (some with commas, dollar signs, etc). It’s best if you input the information as plain integers and let the system organize it based on the format you dictate (either with decimals or with percentages, etc).
To correct this issue, you will need to identify the rows contain the incorrect formatting and remove it.
- Change your column formatting to No Formatting. This should leaving you with the ability to identify the manually added formatting.
- After removing all extra formatting that is not an integer, you can change your column formatting back to a currency value and re-calculate your value Reports.