Spread Sheet Total Figure Issue

Question

Dear All,
For inventory valuation, we have a large dataset. To manage the required information, we switched to pivot view and inserted the data into a spreadsheet. Currently, we are using spreadsheets saved under documents. However, we have noticed some discrepancies in the totals.
Odoo is providing one total value, but when we use the Sum formula for the same column, the totals do not match.
Turn on Debug
Go to Inventory -->Reporting-->Valuation
Group By “Product”

Insert to Spreadsheet

D

Ajin A K · Answer

Hi,
If you're having trouble summing amounts in your downloaded Excel file, it might be because some cells in the amount column are formatted as text instead of numbers. To fix this, follow these steps:

1.
Select all the cells in the amount column.

2.
*Change the format to "Number"* (you can usually find this option by right-clicking on the selected cells and choosing "Format Cells").

3.
*Now you can use the SUM function* to calculate the total amount!
Hope this helps!

Publications associées	Réponses	Vues
How to get inventory report for a specific date in the past? inventory reporting valuation odoo16	4 juin 24	9964
Inventory Valuation in Inventory in Odoo v12 inventory valuation	2 juin 24	6216
Error when doing Manual Value Revaluation inventory valuation	0 mai 23	3904
Historical Inventory Valuation by Location inventory valuation	2 oct. 25	5123
Immediate transfer validation bug from Quality enterprise module Résolu inventory enterprise	1 mai 21	5099

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !