Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Calculated Field Error: Incorrect Result, Formula Corrupts on Requery

Dave05
New Member

I have a data base from Google Sheets detailing an organization's expenses, which is linked to another database that details the established budgets. I have created a table to compare the monthly expenses and budget. The expense and budget values are correct, but when creating a calculated field on this table to divide "expenses" by "budget," the resulting value is incorrect.

Dave05_1-1722792366410.png

Dave05_0-1722792304821.png

In the first row, the value should be: (172,381.94/205,238.18) = 0.8399..., but instead, it shows 175.64.

Additionally, when I review the formula, it appears to be corrupt and is displayed as follows:

Dave05_2-1722792572565.png

I have tried various methods to resolve this issue but have not been successful. Dear forum, I seek your assistance.

 

 

 

1 1 364