-
1. Re: LOD calculation question
ShivaRam Chennapragada Nov 18, 2018 1:32 PM (in response to Oyin T-O)Hi, what do you mean by end in an 'x'? Do you mean a portfolio name that ends with an x? If not, what is x? Also, a packaged workbook with some sample data would be helpful.
-
2. Re: LOD calculation question
Jennifer VonHagel Nov 18, 2018 3:13 PM (in response to Oyin T-O)Hi Oyin,
If you could post a bit of sample data it would be helpful.
Number of Portfolios that end in an 'x' per Billing Group
{ FIXED [Billing Group] : COUNTD(IF RIGHT(lower([Portfolio]),1) = 'x' THEN [Portfolio] END) }
Sum of Records per Billing Group where Portfolio ends in 'x'
{ FIXED [Billing Group] : SUM(IF RIGHT(lower([Portfolio]),1) = 'x' THEN 1 END) }
Hope this helps,
Jennifer
-
3. Re: LOD calculation question
Oyin T-O Nov 18, 2018 3:00 PM (in response to ShivaRam Chennapragada)Please see.
I'm trying to only show Carole's portfolios with an LOD.
Having the x at the end indicates a closed portfolio.
I am looking to identify all closed portfolios at the household billing level. That means Maddy should not be in my tableau sheet as Maddy still has 2 open portfolios.
Do you see what I mean?
Thanks
-
Anonymized data 2..twbx 13.1 KB
-
-
4. Re: LOD calculation question
Oyin T-O Nov 18, 2018 3:00 PM (in response to Jennifer VonHagel)Hi Jennifer.
Thanks for your response. I have attached a workbook with anonymized data a few minutes ago.
-
5. Re: LOD calculation question
ShivaRam Chennapragada Nov 18, 2018 3:04 PM (in response to Oyin T-O)Oyin- Have you tried the calcs Jennifer suggested? If not, try those calcs to see if they work else let us know.