When using a long formatted search I'll sometimes break it up into multiple lines to ease editiing, ending each line with the \ character.
Note the total is 0, but everything else looks ok.
Doing the same search, but run onto a single line, produces the expected result.
I don't understand what is going on here - should this work or isn't \ to extend a line useable in this context?
Hmm, the calculation works with static table where lines are split apart with a backslash. Example:
It does not work if the table is built with a formatted search. So, not really a good answer, start debugging or do not break the lines