Sitemap

Amicuk Programming Answers

Help with math / calculations in RTF templates

2015-10-11   Views:9

Advertisement

Greetings, I know that there are math capabilities in the templates... I've seen the code samples in the Core Components guide. What this doesn't tell you is WHERE these things would go in a template. And... that... is my question. We are just starti

Greetings,
I know that there are math capabilities in the templates... I've seen the code samples in the Core Components guide.
What this doesn't tell you is WHERE these things would go in a template. And... that... is my question.
We are just starting to use BIP in conjunction with JDE EnterpriseOne (8.12, tool set 8.97.12). For our first attempt we're creating our template over a new report.
I have a template where I sum two different repeating values (through the normal BI Properties) and place these values in two separate cells in a table. I want to sum the two of these together for a "grand" total.
I've seen the "examples" but they really aren't very helpful. The xsfo, etc. for doing addition is fine, but WHAT are the values to add and WHERE does the code go?
If anyone has done something like this or has experience using the embedded code I would appreciate hearing from you.
Thanks in advance

The replay answer
Advertisement
I see what you are saying about the spaces... but it made no difference... still got the error.
The XML file is too large and convoluted to be pasted here.
With reqards to the following snippet:
COLA = <?sum(current-group()/COLA)?>
COLB = <?sum(current-group()/COLB)?>
Summ== <?sum(current-group()/COLA) + sum(current-group()/COLB)?>
Where does THIS code go?
Here is the error detail:
ConfFile: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config\xdoconfig.xml
Font Dir: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\fonts
Run XDO Start
Template: C:\Documents and Settings\jdenison\My Documents\BIP Templates\R5642001\R5642001_TEMPLsave.rtf
RTFProcessor setLocale: en-us
FOProcessor setData: C:\Documents and Settings\jdenison\My Documents\BIP Templates\R5642001\R5642001_RICE0001_D081029_T144059683.xml
FOProcessor setLocale: en-us
java.lang.reflect.InvocationTargetException
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(Unknown Source)
     at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
     at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
     at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
     at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
     at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
     at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
     at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
     at RTF2PDF.runRTFto(RTF2PDF.java:629)
     at RTF2PDF.runXDO(RTF2PDF.java:439)
     at RTF2PDF.main(RTF2PDF.java:289)
Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Method not found 'sum'
     at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
     at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
     at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
     at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
     at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
     at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)
     ... 15 more

Go to See the other 9 answers

Help with math / calculations in RTF templates

Category:DefaultRelease time:2015-10-11Views:130

Greetings, I know that there are math capabilities in the templates... I've seen the code samples in the Core Components guide. What this doesn't tell you is WHERE these things would go in a template. And... that... is my question. We are just starti[More]

Can we do Calculations in RTF Template

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends Can we do calculations in RTF template with the fields existing in the XML code. Say there are 2 fields CF_TAX1 and CF_TAX2, can we do calculations with them to give output in a cell in a table in the RTF template for eg: (CF_TAX1)/(1+CF_T[More]

Calculations in RTF Template

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am new to BI Publisher and I am trying to create a template that will calculate growth for various fields. The data is split like (ignore # - using to show structure of XML): <YTDKPI> ###<YTDKPI_ROW> ######<FIELD 1>(Val)</FI[More]

Creating Calculations in RTF templates

Category:DefaultRelease time:2015-10-11Views:130

Is there any way of creating calculations or formula functions within rtf's?http://blogs.oracle.com/xmlpublisher/discuss/msgReader$75Read other 2 answers[More]

Calculation in rtf template

Category:DefaultRelease time:2015-10-11Views:130

I got error when I perform calculation in a field, the code is <?sum(current-group()/_IFNULL__BE_measures_._TOTAL_COST___0_) div sum(current-group()/_BE_measures_._GROSS_SALES_)?> It shows errors: Caused by: oracle.xdo.parser.v2.XPathException: An i[More]

How to select specific rows in rtf template for complex calculation

Category:DefaultRelease time:2015-10-11Views:130

Hi, I want custom calculation in my rtf template and for this i need to select specific cell's value OR specific row's value. Any one please suggest how can I get this. Below is the example i have plotted using excel. My target is to get field 8 and[More]

Creating Parameters in RTF Template for BI Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

hi, I have created Parameters in my BI Publisher Report and in SQL query. But i need to create same parameters in RTF Template , so that when i publish this report in dashboard , parameters will be visible. Can you please tell me how to create Parame[More]

SUM Function in RTF Template

Category:DefaultRelease time:2015-10-11Views:130

Hi buddies, can we use functions like SUM,AVG etc. in the RTF Template. If possible please give adivce for the below scenario I have one column in the main body table "Extended Amount", I want to sum this field for the another column Total Exten[More]

SUM function with condition in RTF template

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a problem in calculating the SUM in RTF template with condition, Here is the XML - <LIST_G_LINE_NOTES> - <G_LINE_NOTES> <LINE_TRX_ID>1567856</LINE_TRX_ID> <LINE_ID /> - <LIST_G_TRX_LINE> - <G_TRX_LINE&[More]

Multiply 2 variables in RTF templates

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to multiply a variable with a calculated field--> <?xdoxslt:get_variable($_XDOCTX,'baseline')*(xdoxslt:maximum(current-group/TRGT_RATIO))?> where "Baseline"=xdoxslt:div(sum(current-group()/NMRTR),sum(currnet-group()/DNMT[More]

Issue in grouping in RTF template

Category:DefaultRelease time:2015-10-11Views:130

HI ALL, I have a requirement as below. The report header part contains : Order number, Email_address, the report body part contains the details for each order like item number, item name Again the line section is based on the another group, so it sho[More]

Hot
Can you add to the Lightroom an ability to process several raw files with the same content but with different exposure into the single picture? Base raw files can be given with exposure bracketing during shooting, for example. The goal - to get maxim [More]
Hello, I'm loading AR invoice using Autoinvoice Import Program. This works fine for invoices with single lines. When I have invoices with more than one row it errors out. The Autoinvoice program completes with Error. For loading multiple lines to the [More]
Using Macbook Pro with CS5 Photoshop and Lightroom 5. Importing photo from LR to PS was told to update PS Camera Raw plugin to 8.2 Used download for Raw/DNG 8.2 and went through the steps to download successful. When I check the plugin status on PS i [More]
Hey, i have some Problems with IPv6 configuration on Solaris 10 (SPARC). I can't configure an physical Interface with an IPv6-address. Every way I choose to configure, Solaris always create a virtual Interface, and give this Interfface the IP-address [More]
Hi, I have added  OM IT 1008 to PPOME. But somehow, the option to edit, create , delete it, is missing in PPOME. do you know how to fix this? Regards KPDear KP, You can use the T-Code PO13 to maintain the infotype 1008 i.e. account assignment feature [More]
I'm a newer on JSP. I need to get JSP run on win NT 4. That is the only server available for me. I'm wondering that the tomcat could work with IIS. If not, what do I need? Anybody, please help me. chayaweeTomcat can be configured to work with IIS or [More]
Dears , I am try to find any solution about Multiple composite primary key by search in forum , but i didn't success ... i am try to built master detail , the master structure table built with multiple composite primary key , i know that apex 4.2 sti [More]
In oracle application there is a schema FND. What does it stands for or it's descriptive meaning? Thanks.hi warren, FND stands for foundation tables which is combination of AOL SYSTEM ADMINISTRATOR MODULES tables will be placed under this FND_TOP Thi [More]
how to create the dropdownlist program?Hi see the sample program REPORT zwa_test2. TYPE-POOLS : vrm. tables: bkpf. DATA : values TYPE vrm_values. DATA : wa LIKE LINE OF values. PARAMETERS : list_box(10) TYPE c AS LISTBOX VISIBLE LENGTH 10. PARAMETERS [More]
Post Author: Skip CA Forum: Formula I have a report that is based on a PSoft query.  There is a selection prompt built in to the query.  I have another report, based on a different query,  that prompts on the same field as the first. I want to bring [More]