Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Summation Issue - Table View

KBabuJan 24 2013 — edited Feb 4 2013

Hi

I have 3 columns (Area Name, Area Desc, Area Num, Amount). I am using 10g obiee

User requested me with some condition to populate the name based on Number like below

Ex: CASE WHEN "Area" = 68 AND "Area Desc" = 'Layout' THEN 'Colony' ELSE NULL END

No Probs in results for showing Area as 'Colony'...but problem is when viewing in TABLE view clicking Summation (Sigma symbol)...Results are not correct..!!!

Area Area Desc Amount
70 abc 1
69 def 2
Colony Layout 3
71 gfg 4

Summation when i totals after............i am getting '1'...but actually sum is '10'

but when i remove any one of the above condition (Say "Area Desc" = 'Layout') and viewing the table and doing Summation... Results are coming correctly (ie 10)...Why it is like that...

Can i get a help

Edited by: KBabu on Jan 24, 2013 5:11 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2013

Added on Jan 24 2013

#applications, #business-intelligence-applications, #obiee

11 comments

208 views