What do you expect from the test? To be honest, I have no idea about testing the result of visuals. For example, generally, the formula could return a value. How can we test if it's correct? If it returns the row total, it could be wrong due to we want the total of the whole column. It also could be correct because the row total is what we need.
Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.