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