The previous method of calculating the "score" relied on utilizing Coalesce alongside the result of the Sum() operation. I came across a similar scenario discussed in this Django forum post. However, relocating the Coalesce to encompass the entire Subquery caused the values to drop to 0.
The previous method of calculating the "score" relied on utilizing
Coalescealongside the result of theSum()operation. I came across a similar scenario discussed in this Django forum post. However, relocating theCoalesceto encompass the entire Subquery caused the values to drop to 0.Issue: https://github.com/PuzzleTechHub/myus/issues/28