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.
Mathematics wise sum(DOLLARS.SELL_AMOUNT-IFNULL(DOLLARS.partial_summed, 0)) you can take out and just use
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
thanks for ur reply..
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
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??
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