How to calculate  revenue vs taget in obiee11g (running every day)

Advertisement
hallo masters,
i have problem,
i have target in 1 year (january until dec) e.g 1000
and then there is revenue every day that calculate until reach 1 year
how can i calculate revenue vs target current day (i only have 1 year target, not target daily or monthly)
and how i can calculate persentage of revenue based on target
revenue 1jan2013 until 25march2013 | target 1jan2013 until 25march2013 | %target | % revenue base on target
and i need to know if % revenue less than target, then mark red
and that calculate every year (runnig revenue and running target)
please help mee
Edited by: xavier_obieenewbie on Mar 25, 2013 2:35 AM
Advertisement

Replay

whether this KPI can change every day base on target and revenue?
because we need running target, it means that target every day increase
target 1jan2012: target 1 year /356
target upto 2jan2012: (target 1 year /356)*2
target upto 3jan2012: (target 1 year /356)*3
target upto 4jan2012: (target 1 year /356)*4
...etc
revenue 1jan2012: a1
revenue upto 2jan2012: a1+a2
revenue upto 3jan2012: a1+a2+a3
revenue upto 4jan2012: a1+a2+a3+a4
...etc
e.g. this day is 4jan2012
so we want to compare revenue upto 4jan2012 vs target upto 4jan2012
whether revenue more than or less tahn target,
its running every day

How to calculate Revenue

Hi Gurus, Please write me a code for the following requirement. This is for using in a report in BI 7.0. I have to calculate the field “Revenue in Future years” from the field “Revenue” .I.e. the source field is “Revenue” and the data source from whi

Code to calculate Revenue

Hi Gurus, Please write me a code for the following requirement. This is for using in a report in BI 7.0. I have to calculate the field “Revenue in Future years” from the field “Revenue” .I.e. the source field is “Revenue” and the data source from whi

How to calculate the number of operations in Undo/Redo stack?

How to calculate the number of operations in Undo/Redo stack? I tried to override UndoManager.pushUndo method and increment "operationsCounter" there, but pushUndo is called each time I make a change in text. Another idea was to override EditMan

How to calculate table size given the structure.

Today i was asked how to estimate the size of the table given th transactions,. table has 90 column all varchar(10) How to calculate the size of table which has no data. Message was edited by: Maran.Ehi, SQL> create table test as select * from all_ob

HOW TO CALCULATE OPENNING BALANCE

HI Experts.. How to calculate Opening balance for previous period using variables in Reports using debit and credit. Example: Opening balance is the balance for an account for the previous period. In other words, if the user is running a report for P

Doubt  in  how to   calculate  net  due date

Hi.. Experts   i have   doubt  in my  salesmen  ageing  report  i have to  display netamout    day  wise  in the range of   0-30 days , 30-60  days and  > 60 days how to calculate  the date difference between  to  date  one is invoice creation  date 

How to calculate Execution Time

Hi gurus, Can any one tell me how to calculate the Report Execution time in Seconds. We have one requirement.My manager told me track all the reports in Development server how much time those take to execute. and Compare those with Production server.

How to calculate the total running time for process from sysssislog entries

Hi All, I have the below query which gets me the log entries form the logs table when the process started/completed. Select row_number() over (order by starttime) row_num,Substring( Substring(message, CharIndex('''',message) +1 ,Len(message)) ,0, Cha

How to calculate age in oracle

Hi, T was trying do calculate age as on todays date in ORACLE but after a lot of brain storming i didn't get it. Kindly tell me how to calculate age as in years month days. For ex.. My DOB- 02-feb-1984 so my age should get as 27 Years 2 months 8 days

How to calculate the phase difference between two square wave (acquired from two channel in one DAQ)

Hello everyone ,  I need a quickly help that as below : I am trying use PCI-6220 to acquired six signals from one rotation encoder (channel A, channel B,channel Z ,and their non-signals) .The encoder out signals will be square wave and 4000pulses per

How to calculate sum in jtable

Hi,i want to ask.Can you teach me how to calculate sum in jtable?For example i got rows of qty,price and total.The total is null unless the user enter value in qty,and when the user press enter key in the qty,the sum will be displayed in the total.Th

How to calculate penalty interest on customer

hi sap guru's how to calculate penalty interest on customer. what type of settings for  required to calculate . pls tell me.Hi Shiva You have options like Balance interest calculation or item level interest calculation.  You can configure the setting

How to calculate the previous year YTD balance in profit & loss statement

Dear all, I would like to seek for advice on how to calculate the previous year YTD (Year to date) balance in profit & loss statement For example, if I enter May 2009, the YTD value should be a sum up of value from Jan to May. I have tried the curren

How to calculate #Buffer Gets    # Exec           Buffer Gets/Exec

Hi, How to calculate #Buffer Gets,# Execution time,Buffer Gets/Exec for a sql query?Nirmal You can find out these statistics from two places 1) using SQL_TRACE (10046 trace) and then TKPROF (or Autotrace in SQL*Plus) 2) or looking at V$SQL which reco

How to calculate CRC easily

i know why we use crc that is error detection. But i dont know how to calculate it help me out pleaseThis has been asked a few times before. Jim You're entirely bonkers. But I'll tell you a secret. All the best people are. ~ AliceRead other 2 answers

Urgent : how to calculate sub total and grand total in smart forms

Hi Friens..how to calculate sub total and grand total in smart forms..How to print them in smart forms...Also kindly explain how to handle events in smart forms..Thanks in advanceRe: Subtotal with Table Node in smartformsRead other 2 answers

HOW TO CALCULATE NET SALES AND CONTRACT PRICE?

Dear experts, I have the requirement of sales price report the report layout should be Prod descr    material Number   Contract type  contrcat name     rebate  net sales  contract price  units we have the master data information is reside already in

How to calculate total no of days in List column

Hi, I've start date and end date. Can you please help me how to calculate total number of days. Column Name = Leave Start Date (05/02/2015) Column Name = Leave End Date (19/02/2015) Column Name = Total Days (This is calculated column) I used below fo

How to calculate Number of weeks in Year ?? urgent

hi gurus, i have to calculate the number of weeks in year. could you please suggest me is there any function module for that or do we need to create variable to get the number of weeks? regardsGet some pointers frm http://sap.ittoolbox.com/groups/tec