Hyperlink Requisition Identifier

Summary

Want to create a dynamic hyperlink on the Requisition Identifier field to the job on the career section

Content

Hi,

I have a analysis (report) in OBIEE which is scheduled to appear in Excel format to users. This report as the Requisition Number (Requisitions Identifier) field included, i would like this field to appear as hyperlink, so when users click on the Requisition number hyperlink in the report it will take them to the job on the career section. 

I have inserted a formula on the column (sample formula below)

<a href="https://companyname/careersection/int/jobdetail.ftl?job="Requisition