Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I want to achieve the following but am not having any luck. Any help appreciated:-
I want to count(green) all accountNo. or lines where the Member = 'Yes', and the AccountNo and productClassifation are the same.
Count | ||||
4 | ||||
AccountNo | AccountName | Member | ProductNumber | ProductClassification |
2500 | Red Sox | Yes | 503650 | RedBox |
2500 | Lost and Found | Yes | 502144 | Glass |
2750 | Blue Bears | No | 502014 | RedBike |
2700 | Green Toads | Yes | 502260 | RedDoor |
2700 | Green Toads | Yes | 502874 | RedDoor |
I'm trying :-
=if(IsMember='Yes',count(DISTINCT[AccountNo]&[AccountName]&[ProductClassificationSummary]) )
Add all the filters in your set analysis:
{<Member = {'Yes'}, Product = {'Active'}>}
I don't understand your second condition, but may be this:
Count(DISTINCT {<Member = {'Yes'}>} [AccountNo]&[AccountName]&[ProductClassificationSummary])
HI,
Try like this
Count(If(IsMember='Yes' OR AccountName LIKE '*Green*', AccountNo))
Regards,
jagan.
Thanks Sunny.
how do I keep adding parameters please.
I.e. I need to add if Product='Active'
Add all the filters in your set analysis:
{<Member = {'Yes'}, Product = {'Active'}>}
Thanks Sunny
No problem at all
Hi Sunny,
if i need to use "and" to make sure both parameters are met , how can i do this? i tried using and, then & without success.
Cheers
The comma separated list within a single set analysis usually works like an 'AND'. Is it not giving you the right output?
no. hey, how do i exclude the title from being included in the count. i've added one but that stuffs up the formula when i select one account to look at.