Categories
- All Categories
- Oracle Analytics Learning Hub
- 20 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Conditional formatting in XML rtf Template (want to format the cell to red color when total is < 0)
Summary
Conditional formatting in XML rtf Template (want to format the cell to red color when total is < 0)
Content
Hi,
I want to conditionally format the cell to red color when when the total is < 0. I used the below tag, it is giving me error "Caused by: oracle.xdo.parser.v2.XSLException: <Line 136, Column 100>: XML-22047: (Error) Invalid instantiation of 'Attribute' in 'Element' context.".
Tag used:
<?if:CF_DELTA_BG_TOT<0?>
<xsl:attribute xdofo:ctx="block" name="background-color">red</xsl:attribute><?end if?>
Appreciate help.
Screenshot below. (output type : excel)
Thanks
Sreedhar
Answers
-
Check Conditionally Highlighting a Row in below
<?if@row:number(SAL)>2000?><?attribute@incontext:color;'red'?><?end if?>
0 -
this worked for me.
The correct condition is:
<?if:CF_DELTA_BG_TOT<0?>
<span style="font-size: 10.0pt; color: #333333;"><xsl:attribute name="background-color" xdofo:ctx="incontext">red</xsl:attribute></span><?end if?>
0 -
Hi, Please find the below error after using the above tag.
0