'HyperLink in Webi Report not responding

We can't click or right click the link on the WebI report that usually downloads an Excel sheet, However we can click it when we export the report to PDF format or opening through an Internet Explorer, however Chrome and Edge is not recognizing the link.

Below are the script used for the link

=If([Condition_A]="(Unknown)") Then "<a href='"+[File_Location]+"' target=_blank>LINK</a>" Else "<a href='"+[File Location_2]+"' target=_blank>LINK</a>"

Please do provide an Solution



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source