RTF Formula Divide Issues — Oracle Analytics

Oracle Analytics Cloud and Server

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

RTF Formula Divide Issues

Received Response
73
Views
2
Comments

Summary

RTF Formula Divide Issues

Content

Hi All,

I need to convert this Crystal reports formula to a BI Publisher formula:

Crystal Reports Formula:
truncate(( ({WYOCN007.SUM_LIMIT_AMT}* 1.05)/100000) + 1) * 100000

My Word RTF BI Publisher Formula that isn't working:

<?xdoxslt:truncate(( (SUM_LIMIT_AMT * 1.05)/100000 ) + 1) * 100000?>

When I validate my template without this formula I get no errors. With this formula, I get the following BIP RTF validation errors:

[121917_100029153][][ERROR] [Line 174.192] Incorrect XPath: xdoxslt:truncate(( (SUM_LIMIT_AMT * 1.05)/100000 ) + 1) * 100000

[121917_100029162][oracle.xdo.template.rtf.RTFTextParser][ERROR] [Line 181.76] <?end if?> cannot close <?for-each:current-group()?> at [Line 123.139]

[121917_100029170][][ERROR] [Line 192.221] Illegal closing table XSL context for: xsl:for-each

[121917_100029174][oracle.xdo.template.rtf.RTFTextParser][ERROR] [Line 202.139] <?end for-each?> cannot close <?for-each-group:WYCN007;./B.WYO_LETTING_DATE?> at [Line 92.217]

[121917_100029191][][ERROR] [Line 230.213] Missing body begin XSL context for: <?end for-each-group?>

[121917_100029203][][ERROR] [Line 346.66] Last XSL context: <?for-each-group:WYCN007;./B.WYO_LETTING_DATE?> (<xsl:for-each-group select=".//WYCN007">) not closed.

What am I doing wrong? I think the issue is near the division maybe? If I simplify the formula to <?xdoxslt:truncate(( (SUM_LIMIT_AMT * 1.05) ) + 1) * 100000?>, removing the / I get results... albeit the wrong ones.

Thank you for your help.


John

Answers

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Oh, I think I just answered my own question.... division is div and not /

    So, <?xdoxslt:truncate(( (SUM_LIMIT_AMT * 1.05) div 100000 ) + 1) * 100000?>

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    Mark it as correct answer if u say its right it will be helpful for others