function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Bad Format of name while exporting the report

Hi  - I am getting a bad formant for account name and opportunity name while i am exporting the report in to excel. opportunity name is being reffered as "_HL_ENCODED_" + salesforce link to record + opportunity name + "_HL__blank_HL_". I could not find what is the issue here. can you please help ?


FYI...they are the formula fields in custom object with Hyperlink function in the formula


Hi Jagan, 


The Formula fields are not values stored in records but the formula is calculated and displayed only upon Loadig of the Record's page. 

Hence when exported the formula is not calculated at the time of export but the value in the field is getting exported. 

The work around would only be writing the formula in excel again where ever possible. 

See the blog might help,

Vote for the related Idea in the Exchange: 




If your question is Answered, please mark this post as solved.