Forum Discussion
Formula to sort by accuracy (absolute error)
Hello everyone, I need some help. Any advice will be appreciated, especially if someone can explain. I have such a visualization. I need to sort by lowest forecast accuracy. ...
Anonymous Why not something using absolute value? Like:
Error = ABS([Accuracy] - 1)
Anonymous Thank you very much for your reply.
I am not sure but something is totally wrong, it doesn't calculate correctly. That's what I have now.
Calculation for Accuracy
And calculation for Error
Anonymous What do you mean by "it doesn't calculate correctly"? What is the actual result you are expecting? It seems to me like it is operating as intended - the are sorted by worst to best accuracy. To see the most accurate values just sort in ascending order.