Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
That did it! THANK YOU! Here is how it ended up looking (in case you are interested) SUM(CASE WHEN COUNT( CONCAT(UPPER("Location"."Address1"), UPPER("Location"."Address2")) BY CONCAT(UPPER("Location"."Address1"), UPPER("Location"."Address2")), "Agent"."Agent ID" ) > 1 THEN 1 ELSE 0 END BY "Agent"."Agent ID" )
-
That is perfect. Thank you!
-
Yes, thank you. I just went ahead & did what you were suggesting & created a filter in the criteria. It worked. I'm still left wondering why the 'Selection Step' method was returning that one 'rank 86' row. It just makes no sense to me. Oh well...I may be left to always wonder...but at least my report is built! Thanks…