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!

Relaterade inlägg	Svar	Vyer
How to get inventory report for a specific date in the past? inventory reporting valuation odoo16	4 juni 24	10004
Inventory Valuation in Inventory in Odoo v12 inventory valuation	2 juni 24	6250
Error when doing Manual Value Revaluation inventory valuation	0 maj 23	3932
Historical Inventory Valuation by Location inventory valuation	2 okt. 25	5142
Immediate transfer validation bug from Quality enterprise module Löst inventory enterprise	1 maj 21	5135

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!