-
1. Re: Custom Calculation
Hi Jenna,
You can try below logic:
{Fixed [telephone number] : SUM([Number of Records])} < 10
Drag this to filter and select "TRUE".
-
2. Re: Custom Calculation
Hi,
Thank you for this calculation. I tried this; however, it is still counting all records and not the ones phone numbers that have less than 10 calls. Not sure why that is. I selected True on the filter. Do I need to show the filter?
Jenna Caprara, CIA, CFE | Internal Audit Manager
601 E Street, NW|Washington, DC 20049|B10-423
Office: 202.434.2353 | Email:jcaprara@aarp.org
For more information, visit Internal Audit<http://infonet/ogc/aas/Pages/default.aspx> on the InfoNet to learn about our services.
This message from Internal Audit may contain confidential or privileged information. If you received this transmission in error, please contact the sender or call us immediately at (202) 434-2350. Disclosure or use of any part of this message by persons other than the intended recipient is prohibited.
-
-
-
4. Re: Custom Calculation
Hi Jenna,
Please see attached workbook solution (2018.2 ver) and below screenshot. I mocked up some phone number data (duplicated some not others):
Hope this helps. Thanks, Don
