
Re: Counting if .... is greater than AND...
Stefan Wühl Oct 9, 2017 4:39 PM (in response to Leo Harper)Count({<PhoneNumber = {"=Count(DISTINCT CallType)=2"}>} PhoneNumber)

Re: Counting if .... is greater than AND...
Leo Harper Oct 9, 2017 4:52 PM (in response to Stefan Wühl )Hi Stefan,
Would you mind explaining this please, what does the 2 in the formula represent? Is it a phone number that matches both phone call types?
many thanks,
Pokes

Re: Counting if .... is greater than AND...
Stefan Wühl Oct 9, 2017 4:55 PM (in response to Leo Harper)This part in the expression is called Set Analysis:
{<PhoneNumber = {"=Count(DISTINCT CallType)=2"}>}
It's basically filtering your PhoneNumber by using an expression search:
Only include the number in the set to aggregate where the distinct count of CallType values is 2, i.e. both Work and Private calls have been made (assuming that these are the only existing types).

Re: Counting if .... is greater than AND...
Leo Harper Oct 9, 2017 5:05 PM (in response to Stefan Wühl )Ok, i got it. Many thanks  I'l try this at work tomorrow too.
Cheers,
Pokes
Re: Counting if .... is greater than AND...
Damian Spyra Oct 10, 2017 1:34 AM (in response to Leo Harper)Hi Pokes,
I think, Stefans solution is the best fit for your needs.
Have a wonderful day!
Damian

Re: Counting if .... is greater than AND...
Leo Harper Oct 10, 2017 4:52 PM (in response to Damian Spyra)Hi Damian,
Yeah it looks like a good solution, unfortunately its showing an 'error in expression' alert  any ideas?
cheers,
Pokes





Re: Counting if .... is greater than AND...
Leo Harper Oct 10, 2017 3:50 PM (in response to Stefan Wühl )Hi Stefan,
Tried your formula at work today, unfortunately it gave an 'error in expression' warning. Any ideas??
cheers,
Pokes

Re: Counting if .... is greater than AND...
Damian Spyra Oct 10, 2017 3:54 PM (in response to Leo Harper)Hi Pokes,
can you paste your formula to show the syntax?
Thanks
Damian

Re: Counting if .... is greater than AND...
Leo Harper Oct 10, 2017 4:53 PM (in response to Damian Spyra)Damian,
I'm using the formula exactly as suggested by Stefan...
Count({<PhoneNumber = {"=Count(DISTINCT CallType)=2"}>} PhoneNumber)
not too familiar with set analysis so not sure how / what to amend.
cheers,
Pokes

Re: Counting if .... is greater than AND...
Stefan Wühl Oct 10, 2017 6:04 PM (in response to Leo Harper)Double check that field names are spelled correctly (and take care of upper / lower case).

Re: Counting if .... is greater than AND...
Lok Mikklineni Oct 10, 2017 6:39 PM (in response to Stefan Wühl )






Re: Counting if .... is greater than AND...
Damian Spyra Oct 9, 2017 4:44 PM (in response to Leo Harper)Hi Pokes,
you could use kind of additional flag field like "_work" and "_personal".
Then you can evaluate: if( _work * _personal, Phone Number)
Cheers
Damian

Re: Counting if .... is greater than AND...
Leo Harper Oct 9, 2017 4:53 PM (in response to Damian Spyra)Thanks Damian, I'll try this at work tomorrow
cheers,
Pokes
