Multiplying, dividing and adding decimal numbers formula in CODA. Any Ideas?

Hi. I am working with a table that has decimal numbers with 3 numbers after comma in its columns. for example TWA= 0,346 (702 divide by 480). I have used this formula [thisRow.[Corrected Sample Mass]*thisRow].[Sample duration in Minutes]/480 but the answer it gives is wrong. In areas where I only have 2 or 1 numbers after comma it return an error unless I add one a zero or two zeros after the comma to make 3 numbers. Even in such situation my answer is wrong. In my mathematics I am suppose to divide numbers inside the brackets first so that it turns into a decimal number too before multiplying with external decimal number. Another formular that also gives wrong answer is [thisRow.[Pump Flow Rate After] * thisRow.[Sample duration in Minutes] / 1000] The flow pump rate is a decimal number with 3 numbers after comma. Minutes are a whole number divided by thousad to turn this into a decimal number before multiplying. I am supposed to do division of the minutes by thousand first before multiplying by the pump flow rate after to get decimal number that will be multiplied with another decimal. I seem unable to find an idea to create a CODA formula that will represent this action. Does anyone have an idea?

1 Like

Coda has no issues dealing with basic arithmetics. I suspect the issues are that you might be using commas , instead of points . as a decimal separator and square brackets [ ] instead of parentheses ( ).

But we can’t tell you for sure where the mistake is unless you share a dummy doc with us.

1 Like