This discussion is archived
5 Replies Latest reply: Mar 22, 2013 4:09 AM by Srini VEERAVALLI

# problem with calculation

Currently Being Moderated
Hi Experts,

I need guidance ..

i have one report which was migrated from 10g to 11g.

in the report one measure column is there in that i am having formula like

SUM(SUM(DOLLARS.SELL_AMOUNT-IFNULL(DOLLARS.partial_summed, 0))*DOLLARS.RATE)/SUM(DOLLARS.SELL_AMOUNT-IFNULL(DOLLARS.partial_summed, 0))

same formula is used in the 10g and 11g but data is not matching between the reports.

cani know is there any needed changes for the formula in 11g, like grouping or something...

NOTE: when i place the DOLLARS.RATE column in the report data is matching with 10g, when i removed the DOLLARS.RATE data getting effecting. but i don't need this DOLLARS.RATE in the report.
• ###### 1. Re: problem with calculation
Currently Being Moderated
Mathematics wise sum(DOLLARS.SELL_AMOUNT-IFNULL(DOLLARS.partial_summed, 0)) you can take out and just use
sum(DOLLARS.RATE).

Try to use the Pivot table view with DOLLARS.RATE and put this column in excluded section that might help you.

if need send me screens with column and without to check the data
• ###### 2. Re: problem with calculation
Currently Being Moderated
Hi Srini,

when i placed the DOLLARS.RATE column in the excluded section in 11g the measure where i written that formula , the entire column is empty , getting nulls.

when i place the DOLLARS.RATE in the excluded section in 10g some data is coming how this is happening??

Edited by: Bhargav K on Mar 21, 2013 5:50 PM
• ###### 3. Re: problem with calculation
Currently Being Moderated
BOSSSSSS!!!!!

I was asking you to put DOLLARS.RATE in excluded section and the same what you've used with that expression.

Use little ;)

Thanks
• ###### 4. Re: problem with calculation
Currently Being Moderated
Hi Srini,

thankq....its worked...but i have 2 more measures like that with different formula for that what i need to do??

should i have repeat the steps like before or is there any work around for that??
• ###### 5. Re: problem with calculation
Currently Being Moderated
When It worked I expect this as answered and marked as correct.

For your Q; I would try my self first rather than asking some one who blindly throws answers in dark ;)

Thanks ie. No more responses on this from me :)

Edited by: Srini VEERAVALLI on Mar 22, 2013 6:08 AM

#### Legend

• Correct Answers - 10 points