Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
RTF Formula Divide Issues

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
-
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?>
0 -
Mark it as correct answer if u say its right it will be helpful for others
0