Hey guys, I need to make a simple sum, but didn't work out very well...
I need make this calculation:
% = TrabalhoRealdaTarefa/(TrabalhoRealdaTarefa+TrabalhoRestantedaTarefa)
But i made this:
Hi @Gorilla_8
The first thing I'd check is that you're referring to the correct data. In this example, are you expecting the result "37,77%"? eg (51/(51+84) * 100)?
I see that your formula refers to the record First(collTaskRow). Is this the record that you're intending to use?
To avoid any problems in retrieving the correct record, in this example, it might be easiest for you to reference the textbox values directly.
Text((Value(TextboxReal.Text) / Value(TextboxReal.Text) + Value(TextboxRestante.Text)) * 100 )
I think I fix it...
Sum(Round(Value(Text(First(collTaskRow).TrabalhoRealdaTarefa / Value(Text(First(collTaskRow).TrabalhoRealdaTarefa + Value(Text(First(collTaskRow).TrabalhoRestantedaTarefa))))));4)*100) & " %"
User | Count |
---|---|
256 | |
111 | |
95 | |
48 | |
40 |