Sitemap

Amicuk Programming Answers

How to round numbers in RTF templates?

2015-10-11   Views:23

Advertisement

Hello! I'm using BI Publisher for Word (Oracle BI Publisher Builder for Word 10.1.3.4.1) to build a template to my BI Publisher report and I want to calculate this: avg(X)/(avg(Y)-avg(Z)/0.9) The result should be rounded to 3 places. I tried: <?(sum(

Hello!
I'm using BI Publisher for Word (Oracle BI Publisher Builder for Word 10.1.3.4.1) to build a template to my BI Publisher report and I want to calculate this:
avg(X)/(avg(Y)-avg(Z)/0.9)
The result should be rounded to 3 places.
I tried:
<?(sum(X) div count(X)) div ((sum(Y) div count(Y)) - (sum(Z) div count(Z)) div 0.9)?>
and I obtained the expected result.
But, when I try to round in this way:
<?xdofx:round((sum(X) div count(X)) div ((sum(Y) div count(Y))-(sum(Z) div count(Z)) div 0.9),3)?>
I obtain 0 when is expected other value.
Can someone help me?

The replay answer
Advertisement
Hi ,
You can select the number format in RTF template .Double click the Form Field select
Type :Number
Number Format :#,##0.000
Thanks.

Go to See the other 5 answers

How to round numbers in RTF templates?

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

Hello! I'm using BI Publisher for Word (Oracle BI Publisher Builder for Word 10.1.3.4.1) to build a template to my BI Publisher report and I want to calculate this: avg(X)/(avg(Y)-avg(Z)/0.9) The result should be rounded to 3 places. I tried: <?(sum([More]

Page numbering in rtf templates

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

Hi All, I have an rtf template and what I want is to display page numbers. I can achieve this with the following : <?fo:page-number?> but I want to display it by different way: For example if the total pages in the output is 10 pages I want the page[More]

Issue with ROUND function in RTF template

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

Hi All, Can anyone please help me in implementing the ROUND function at the RTF template. Need to handle rounding of amounts at the RTF template level itself. The ROUND function should be implemented to the following tags: <?sum(current-group()/TAXAB[More]

How to Display Page Numbers in RTF Template

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

Greetings to all, We have a requirement in which we have to display the Page numbers on the output PDF. The scenario is , if the PDF contains10 pages,then on Pages , it should show Page 1/10,Page 2/10 etc. And If the output exceeds to more than 1 pag[More]

Round Edged boxes in rtf templates

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

Hi all, I have been really struggling to design rtf templates for XML Publisher with round edged boxes. The client requirement is to have all the tables/objects that contain data to have rounded edges..Just like a flowchart box.. I have tried using t[More]

RTF templates and word cell padding.

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

Hi. I'm having a problem with numbers in an XML Publisher report. Generated RTF templates don't seem to retain the cell padding properties. Has anyone got any suggestions on how to get round this? Thanks. Steve.Well there appears to be a bug in the R[More]

RTF Templates and report file (.xdo)

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

Hi all, I use Oracle report and I would like to migrate from that software to Oracle BI Publisher. During my tests, I encountered various problems like the following: I create my report (.xdo file is generated) in development with one RTF template. I[More]

Reseting page number in Word RTF template for BI Publisher PDF generation

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

Hi! Apex 4.0.2, Oracle 10.2.0.4, BIP 10.2 Bills are created based on Word RTF file with BI Publisher. Reszulting file is one big PDF file, which has many pages. Word RTF template is grouped on BILLS.ID field with page break option. So one BILLS.ID ma[More]

Need help with 'division' operation in RTF template

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

We are using variables in RTF template to perform all data manipulations To calculate columns where we need to do division operation, using '/' or 'DIV' is not working. Using <?xdofx: op1 DIV op2?> is working only when op1 and op2 are numbers like e[More]

Xslt graph in a rtf template. Can an external variable be used inside the graph definition?

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

I'm working with BI Publisher 10g, building an rtf template that would display a table and a graph by iterating on one of the xml tags from the input file. I got the table working using am xslt variable set when the xml tag associated value changes ([More]

Hot
i need to enhance CRM extractor with additional field. This is transactional data so i used Exit_rs_001 Here is the extractor result - Guid...date...........objectid...item guid 1122......1.1.10....901..........8811 1122......2.1.10....901..........8 [More]
I am switching to Mac :-D and now I have a few questions that someone can help me out with a few iPod/iTune questions. 1) Will I need to restore my iPod so that it will be able to talk to the Mac. I believe I will but I want to make sure. 2) I have s [More]
So, I placed my order by 3:35 AM EST for my Silver 6 plus 128GB.  All the way through the process, from selecting the phone to the submission confirmation screen on the web it stated delivery by 9/19.  I received my email confirmation and that showed [More]
I have a macbook pro from 2009. I recently upgraded to Yosemite and now it won't read my external drive (Toshiba). I am able to find it in disk utility but I am not able to open it. The device works fine in other computers. I have all my pictures the [More]
Good day, I am experiencing some challenges with a Project Pro master project file and syncing to SharePoint 2013 (Office 365). What works Individual projects can be synced to SharePoint without issue. Once synced, the site start page presents the Pr [More]
When I want to add an application itunes continually has me sign in, it then tells me this computer is already authorized, then the process starts all over again and no applications get transferred due to this.   I recently deleted files to free spac [More]
Are there any changes to the photoshop elements organizer from version 8 to 9I agree.  In some ways it is a real step backward.  I would not recommend "upgrading" to PSE9 based on one day of working with it.  Lost the ability to see all files in [More]
Hello All, I have a Scenerio where  I require to create Access Sequence with Plant and Sales office with Billing Type Combination. But Plant and Sales Office Fields are not Present in Output Communication Structure KOMKBV3 / KOMPBV3. This is giving a [More]
Several times now I have had users who wanted to move libraries or lists, etc. from one place within a site collection to another. The problem is that often, when they go into content and structure, select their source, the only action that appears i [More]
Hello All, I need to create a z Program and call a screen variant of a standard transaction in it. I am calling a screen variant of transaction PA70 to hide some of the fields of the screen. Also the first screen is supressed. My requirement is while [More]