The error you're encountering, "Failed to convert the value '3.75000000000000' to a number," is likely due to the way SharePoint stores calculated fields with decimal points. SharePoint sometimes stores calculated values with a large number of decimal places, and this can lead to issues when performing calculations in Power Apps.
To address this issue and calculate the sum of the calculated column correctly, you can use the Round function to round the values to a reasonable number of decimal places before performing the sum. Here's how you can adjust your formula:
Text(
Sum(
Inventaire,
Round(Value(TotalValue), 2) // Adjust the decimal places as needed
)
)
In this formula, the Round function is used to round the values in the TotalValue column to two decimal places before performing the sum. You can adjust the decimal places according to your needs.
By rounding the values before summing them up, you can avoid precision issues and ensure that the values are properly converted to numbers without causing the conversion error.
