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]

How to create rtf template to view report in Word and Excel, with numeric f

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

Hi, Please help me! How to create rtf template to view report in Word and Excel, with numeric formatted fields (like this 999 999 999,99 with spaces between numbers) and then end user be able to process those fields with Excel tools (sum, etc). Thank[More]

Hot
We have packaged and deployed Adobe CC using SCCM within my school division. It pushed out fine, but now when we attempt to open Photoshop (or any other CC app) it has unusually long load times. 2-4 minutes. It seems to be hanging at the "Reading pre [More]
Hi I've been trying to figure it out if it is possible to find a song in the playlist by artist and title or any other tag. Something similar to how Sonata filters the playlist. If I search for 'one' I get hundreds of results even tough I only want t [More]
Please note that in the following I'm only concerned about single-statement read committed transactions. I do realize that for a multi-statement read committed transaction Oracle does not guarantee transaction set consistency without techniques like [More]
it was a lot easier that I ever imagined and pretty fun too.  When i started this journey 18 months ago I had zero Credit Cards and a 586 credit score.  Now I have 7 cards with about $25,000 in limits currently under 23% usage and my Discover card FI [More]
Hello, I'm building a JSF webcenter application, which has lots of content that's going to be published using Site Studio. Using Site Studio Designer, I have created: - An element definition (WYSIWYG) - A region definition that contains just the elem [More]
제품 : FIN_AP 작성날짜 : 2004-05-27 GL_INTERFACE 와 PAYABLES 간의 연결정보확인 ================================= PURPOSE Payables Source와 GL_INTERFACE간의 연결정보를 가지고 있는 Column을 알고싶을때 Explanation 1) GL_INTERFACE.USER_JE_CATEGORY_NAME = 'Payments' and USER_JE_SOURCE_NAM [More]
where is iPhoto on my computer??iPhoto is a Mac program for managing your digital photos (downloading from the camera, displaying on your computer and many other things). Do you have a Mac? If not, you don't have iPhoto either. If you do have a Mac, [More]
Hi, I need to write a DECODE function to which if I pass 'mystring' and if it has the value 'M' it should output 'M', if it has a value of 'F' it should output 'F' and if mystring is not same as string_coded then it should output string_coded. I know [More]
OK, I still haven't solved the various problems with printing from Leopard to my Lexmark C530dn but could anyone help me out with what is actually going on here? I've been round the houses so much I need some clarity. This is what I think I have disc [More]
We had purchased one Lenovo laptop (Model :Yoga 13)(serial Number: EBxxxxxxxx ) from M/s.Nirvana Computers, Calicut on 3rd March 2014. On July 23th 2014, we found that the LCD panel was having complaint and we called up the toll free customer care, t [More]