Do you mind sharing a copy of the data to ariesarsenal@gmail.com so I can try directly on it? Thank you. Just that sheet will be enough.
Edit: Found the problem. Don’t use AND in ARRAYFORMULA because it won’t work.
Right formula for your case:
={"Aqius Value";ARRAYFORMULA(IF((H2:H="")*(U2:U="")=1,"",IF((H2:H<>"")*(U2:U<>"")=1,VALUE(U2:U),IF((H2:H<>"")*(U2:U="")=1,"No data",""))))}
You can use the +0 method, or the VALUE one.