Hello,how can I calculate the weighted average? Example:[-4, 0, 2, 0] -> I get this values via a roolupI want the result to be -2 i.g.. Correct me please if I am wrong.I'm open to use multiple formulas. Best regardsJohannes
Hi @drassi ,thanks, this helped me to solve my issue. However, there is no example, so I didn't figure it out the first time.My solution was to return BLANK() instead of a 0, when the Formula encountered a BLANK() at the first or second value. If thi...
Hi @stevendasilva , thanks. I already saw the post. While reading the message more closely, I found out that it actually is the solution for my problem. However, there is no example, so I didn't figure it out the first time.My solution was to return ...
