Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help with completing this statement. How do I combine these.
Currently, the below works to exclude a filter:
count ({<CalendarYear_PE = , CalendarQuarter_PE = >} MYKPI)
But I need to add this to "MYKPI" calculation so that everything works together.
count( {($<A={1}> +$<B={1}>)} DISTINCT(MYKPI))
Please help
Thanks
may be like below
count( {<A={1},CalendarYear_PE = , CalendarQuarter_PE = > + <B={1},CalendarYear_PE = , CalendarQuarter_PE = >} DISTINCT(MYKPI))
May be this?
Count({$<CalendarYear_PE = , CalendarQuarter_PE =, A = {'1'}> + <B = {'1'}>} DISTINCT MYKPI)
may be like below
count( {<A={1},CalendarYear_PE = , CalendarQuarter_PE = > + <B={1},CalendarYear_PE = , CalendarQuarter_PE = >} DISTINCT(MYKPI))
count( {($<A={1}> +$<B={1}>)} {<CalendarYear_PE = , CalendarQuarter_PE = >}DISTINCT(MYKPI))
This one worked great! Yea guys, this one was tricky. Kushal demonstrated the exclusion piece to work by inserting it for A and separately for B.
Also Mangal's solution works but giving me slightly different results which I will have to test why to find out what's going on. My inclination is that 1 solution is giving me where A and B both have a 1, while the other is not.
Thanks guys, this is a great teaching tool!! Really appreciate it!
Thanks. Please mark the answer as correct or helpful so that everyone can refer to this if they have same problem
This also works very well as a solution!