Actually I just realized that the formula above that is working successfully, does not work when summarize is applied. Summarize adds all the combined lines together.

Added:

Nevermind, fixed this by selecting display average instead of display total.