OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » FSG

Home » Applications » Oracle Fusion Apps & E-Business Suite » FSG - calculations

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FSG - calculations [message #178313]

Tue, 20 June 2006 10:15

ERP Consultant
Messages: 17
Registered: June 2006

Junior Member

Hi,

Iam preparing an FSG report wherein column set caculation is required. Iam not able to set the calculations for particular column "Last year % Change"

What amount type do i need to select if iam seeting this column set?
Calculation is:
Actual From last year - actual from this year / actual from last year into 100.

i tried using
(+) for actual from last year
(-) for actual from this year
(/) actual from last year.

but not able to put *into 100???????

please advise.

Thanks.

Report message to a moderator

Re: FSG - calculations [message #178502 is a reply to message #178313]

Wed, 21 June 2006 05:03

David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England

Senior Member

Take a look at the forms.

On the Define Columns form, you could use one of these:

Factor=Percentiles

Amount Type=<one of the %Variance types>. Unfortunately there is not one for this/last year

Percent of Column
OR on the Calculations form, you could use one of these:

(x) CONSTANT 100

(%) calculate % of column

You will find examples of some of these in the pre-defined Column Sets, those where Help, About This Record reveals that they were Created by and Updated by AUTOINSTALL.

Be careful which one you use. If you go your original route, you will hit problems when adding rows together; If row 100 has a calculated %Variance of 30 and row 110 has a calculated %Variance of 50, then the sum of these two rows will give a calculated %Variance of 80 (50+30). Printing one column as a percentage of another should eliminate this. You will need to experiment to find which solution works best for you. I would suggest that you use one of the techniques used in the pre-defined Column Sets.

Cool

HTH

David

Report message to a moderator

Re: FSG - calculations [message #178564 is a reply to message #178502]

Wed, 21 June 2006 09:32

ERP Consultant
Messages: 17
Registered: June 2006

Junior Member

How can i take % of columns cos my formula is

1.(+) Actual From Last Year
offset -12

2.(-) Actual

3. (/) Actual from last year

4. X 100 constant.

I have gone thru the sandbox but could not find any column with this type of caculations.

iam getting the output but its not correct. I am not sure the formula is correct or not?

Help..

Report message to a moderator

Re: FSG - calculations [message #178570 is a reply to message #178502]

Wed, 21 June 2006 09:46

ERP Consultant
Messages: 17
Registered: June 2006

Junior Member

Also wanted to know wat is the relevance of Percentiles as a factor and percent of column.

Report message to a moderator

Re: FSG - calculations [message #178580 is a reply to message #178564]

Wed, 21 June 2006 10:44

David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England

Senior Member

ERP Consultant wrote on Wed, 21 June 2006 15:32

No, you won't find any examples of any column with this type of caculations because it will give incorrect or misleading answers, as per my last reply.

David.

Report message to a moderator

Re: FSG - calculations [message #178584 is a reply to message #178570]

Wed, 21 June 2006 11:05

David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England

Senior Member

ERP Consultant wrote on Wed, 21 June 2006 15:46

Also wanted to know wat is the relevance of Percentiles as a factor and percent of column.

Percentiles will do the equivalent of multiplying by 100. Whereas 30/100 = 0.30, 30%100 = 30.0
Please look at the predefined Column Set called "Annual Comparative QTD, YTD".

If Column 10 is Last Year, Column 20 is This Year and Column 30 is the Variance (Column 10 - Column 20) then you can define Column 40 as being Column 30 as a Percentage of Column 10.

Cool

HTH

David.

Report message to a moderator

Re: FSG - calculations [message #178585 is a reply to message #178313]

Wed, 21 June 2006 11:09

ERP Consultant
Messages: 17
Registered: June 2006

Junior Member

Ok Thanks a bunch. Razz

Report message to a moderator

Previous Topic:	link of sales order with contract
Next Topic:	Setup Documentation Templates for eBusiness Suite Modules

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 14:13:05 CDT 2024