I have a problem with a value I need to use for a math calculation. I’m using a lookup to bring in the value need for a simple tax calculation (amount*tax) that’s it, but! when I use that lookup value and multiply by the amount the result is no what it should be, it’s off. First 2 columns are the …

Short answer is that you are not using 4.25. You are using 4.245967741935484. 4.25 is the “formatted/precious” version of a true underlying unrounded value. Your final math column is using the underlying value. Not the formatted value. Formatted values are used for display purposes only. Not …

My thinking is that what you see on screen (the display) and the actual numbers under the hood are slightly different, and these slight differences could be further enhanced and clearly visible after the math which involves a multiplication? This is a hypothesis I would test. Originally, I assume t…

They are the same. If I choose to display 4 decimals I can “see” that all the numbers are correct. If that’s the case that numbers displayed and numbers stored are different then this is a BUG. If I display more decimals it shows correctly, the problem is in the math operation, which is a ver BIG…

I’ve been testing more and it’s all the same. At some points I can SEE clearly the correct answer for this example (231.88) while the calculation is loading and when I click on the “Done” button, it displays the incorrect answer.

Idea to try to troubleshoot: what happens when you perform the math all in the same table without the relation and lookup?

I’m working with a proposal header and details tables, I need the calculation to be performed where the items are (details). If I don’t find and answer, yes I would have to create an alternative method of getting the items values to do the necessary calculations. But it is not ideal.

My suggestion is to try to identify where the problem might lie, not as a long-term solution. The chain is broken somewhere. Maybe you could share screenshots and we might see something you missed.

Thank you for the video. The column look->ProcDescuentoAplica is looking up a column. Could you show us a configuration of that column please?

Hello Jeff, That’s exactly my mistake. I did now know that I had to use a round function. Just got off an email with support where they explained that the value it was used on the calculation was the complete value, not the displayed value. So I changed it to this: [CleanShot-2023-09-12-at-16-…

Problem with a look number value and incorrect calculations. Has this happened to you?

Ask for Help

globalint September 12, 2023, 8:34pm 11

Thank you for taking the time to take a look into this. The value comes from another math column (in the proposal header table) which is used to generate the value I need to send it to the details table.

Topic		Replies	Views
Need Help: In math column can't we get lookup values if they are numbers? Ask for Help	5	46	December 22, 2024
Using a Look Up value to do math Ask for Help	4	272	September 28, 2022
Sum Number to another Number from a Look Up Not Working! Ask for Help	4	293	March 4, 2022
Set Column with Currency Showing Decimal Ask for Help	13	104	October 6, 2024
Math column problem Ask for Help	3	178	January 19, 2024

Problem with a look number value and incorrect calculations. Has this happened to you?

Related topics