This content has been marked as final. Show 5 replies
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
I was asking you to put DOLLARS.RATE in excluded section and the same what you've used with that expression.
Use little ;)
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