If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Fetching common row on two different conditions

Started by inu, 31 Oct 2017 11:34:45 AM

Previous topic - Next topic

inu

Hi Team,
My requirement is.. I have to take count of I'd on two different conditions as follows
1.Count (distinct case when mndtry='infosec '  then I'd end )
2.Count (distinct case when mndtry='integrity'  then I'd end )

If I write Count (distinct case when mndtry in('infosec ','integrity'  then I'd end )
It doesn't give the correct result more than expectation,
Hence I need to take the count individually on common I'd.

How to achieve this.. Please suggest.


Regards,
Inam