Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi @Jerry Casey@, Thanks, It defo helped, that was it I added it another condition to fulfil my requirements WHEN COUNT("Manufacturer"."Country" by "Manufacturer"."Role", Product Number)>= 1 AND "Manufacturer"."Country" NOT IN ('UK','uk') THEN 'No UK' Else Null And all works now as I wanted. I also understood the way you…