Conditional formatting in rtf template on a calculated column

Helan Kumar

My code is

<?if:xdoxslt:sdiv(sum(TODATE),sum(CAC), '0') >100?><xsl:attribute xdofo:ctx="block" name="color">red</xsl:attribute><?end if?>

Logic:

if (sum(todate)/sum(cac)) > 100 then i have to display results in red color.

This code works fine with out a calculation like below but not with a calculation.

<?if:PCNT_TASK>100?><xsl:attribute xdofo:ctx="block" name="color">red</xsl:attribute><?end if?>

Also tried with <?if:sum(TODATE) div sum(CAC) >100?><xsl:attribute xdofo:ctx="block" name="color">red</xsl:attribute><?end if?>

Calculated values are correct but color coding is not working as expected. Also i can not push this calc to SQL as it is being displayed at grand totals in the template.

Gabriel Grigorie-Oracle

Hello  ,

Kindly please find more details regarding the conditional formatting

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#BIPRD2500

format;

<?if@row:position() mod 2=0?> <xsl:attribute name="background-color" xdofo:ctx="incontext">lightgray</xsl:attribute><?end if?>

For each alternate row, the background color attribute is set to gray for the row.

Thank you
Best Regards
Gabriel