Unable to export "<" symbol in excel — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to export "<" symbol in excel

Closed
1
Views
2
Comments
3612780
3612780 Rank 2 - Community Beginner
edited Aug 13, 2024 5:18PM in Oracle Analytics Cloud and Server

Hi All,

I have used conditional formatting in OBIEE 12c report wherein when data will be less than -100 then "<100%" will be shown as a column value instead of DB value. I have done it through Column properties->Conditional Formatting->add condition->data format and the write below text to show <100% column value.

@;"<(100%)"

So, the output will be:

Column1   Column2

ABC         <100%

So, when we are trying to export the analysis, it is giving 'There was an error processing your download.Please check with your administrator'. Can you please advise how we can update the formula so that this will be export it to excel.

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    If double posting was against the forum's rules, you can imagine that triple posting isn't any better ...

    If you plan to post the same thread daily, please stop.

  • Timo Hahn
    Timo Hahn Rank 4 - Community Specialist

    ***Moderator action (Timo): locked as duplicate.***

This discussion has been closed.