I need the result of the item "QTD S/ PERDAS" to be rounded up in the item "QTD TOTAL", that is, if the result was 0.47 I need it to be 1. However, when I use the formula "roundup" by if several family elements are modeled it will round the results for each element and then add them together, instead of adding all the elements and then rounding up, resulting in a value well above what I needed.
Sounds like you are saying that you want the roundup column to only roundup certain row values, but not others. If so, you might be able to get there with an conditional argument. e.g. =if("this condition is true", roundup(value), value).
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.