Forum Discussion
Solved
Formulas - Somar, subtrair e comparar valores
Necessito de uma função que compara os valores da seguinte forma: Tabela xpot - Banco SQL soma ofensores por demanda; coluna - ofensorqtddiasl; soma por fase excluindo saldo / valor duplicado...
Friends, Thanks for the help, but let's start by extracting the data. There are many errors that need correction. Goodbye .
I need your help, to sum up values by removing the duplicate values.
There are two columns with values:
1-Time of each phases within the project. 2-Time worked on the project.
Values are duplicated within phases (per record line) because there are two or more people who have worked and consumed hours within the project.
The sum of the added values of each project and sum of time worked, compared must be equal. Subtracting from each other would be zero.
v-qiuyu-msft
Community Support
Community SupportHi gus2701,
Please share some sample data and show us the expected results so we can test it.
Best Regards,
Qiuyun Yu