Cubevalue Function to show 0 instead of "" (zero-length string)

Hi!

I want my cubevalue formulas to show 0 instead of "".

I have 260 formulas on my sheet, so I want to have an option where I can use Find-Replace to modify them all (easy for the beginning, 4 options for the end as they all end with one of 4 slicer names). I don't want to copy-paste or rewrite the formula itself, because that would require going into every formula.

I don't want to use IFERROR(VALUE() as I want the formula to show errors if there are any. I have tried other solutions proposed by AI, e.g. multiplying, using SUM(0, ...) as supposedly SUM ignores empty length strings, but these options don't work.

I have seen a similar post with the opposite problem, but I can't figure out how to change the formulas to fit my case...

Thanks for your help!

Edit: I guess there is something that can be done with LET, but I am not really familiar with that...