If you use a Colour Overlay effect on a layer and set the Colour Overlay to use Multiply blend mode, then take two of these layers and try to blend them together with "Add" blend mode then the Add blend mode seems to be ignored.
If you take the two layers and put them each in their own Group it works ok. Or if you "Copy Merged" and re-paste the re-colored layers in a new document then that works (of course, then it's just basic "Add" with nothing else).
It seems wrong that the blend mode used for applying the Layer Effect of Colour Overlay has any effect on the overall blending between different layers.
AffinityBlendIssue.afphoto