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.
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:
I have tried various methods to resolve this issue but have not been successful. Dear forum, I seek your assistance.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |