Hi!
Maybe you mistyped the comand? The tilde does not belong there unless the file is in ‘/home/user/’ - and a slash would still be missing then. If this file you want to install is in ‘/home/user/Documents’ the comand ‘sudo dnf install /home/user/Documents/cav-linux_x64.rpm’ should work.