Hi, I have an issue with one of my templates, where my formula is incorrectly calculating based off of the digits within a number preceding a comma - see below: 1,000 - 800 = -799 [image] This does not seem to be an issue when there is no comma in the value - see below: 750 - 800 = -50: [image] …

Hi @jhanley , The problem is that you assign the value to ‘budgeted_cost’ as an integer. The solution is to delete the pipe with “integer” in the assignment of ‘budgeted_cost’. To display the ‘budgeted_cost’ correctly, you should put the pipe with integer behind ‘budgeted_cost’ when printing it: {%…

Formula incorrectly calculating based off of digits within a number preceding comma

Templates

jhanley September 15, 2020, 2:25pm 3

Thanks @Ward_Lostrie, this is exactly what I was looking for.

Works like a charm once you know how!

Joe

Topic		Replies	Views
Rounded numbers and calculating with the full number Templates variables , attribute_currency , attribute_percentage	1	539	June 6, 2018
Rounding differences Templates variables , math , filters , attribute_currency	8	577	June 12, 2017
Alignment of negative number shown in parenthesis vs positive number in a table Templates	8	430	March 26, 2021
Custom report - problem with Formulas Reports math	5	562	March 10, 2017
Costs non commercial Templates references , tables , alignment	34	778	March 22, 2017

Formula incorrectly calculating based off of digits within a number preceding comma

Related topics