5 Replies Latest reply on Nov 18, 2018 3:04 PM by ShivaRam Chennapragada

# LOD calculation question

Hi all, I am trying to get a calculation but I keep getting errors. Can you please help with this LOD calculated field?

I have 2 dimensions concerned; Billing groups and portfolios. Billing group is the higher heirachy, and so 1 billing group may contain several portfolios.

I'm trying to calculate

Maximum number of PORTFOLIOS that end in an 'x' within my BILLING GROUP

or the number of records of PORTFOLIOS that end in an 'x' in my BILLING GROUP

Can anyone help with a formula?

• ###### 1. Re: LOD calculation question

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

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

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

• ###### 4. Re: LOD calculation question

Hi Jennifer.

Thanks for your response. I have attached a workbook with anonymized data a few minutes ago.

• ###### 5. Re: LOD calculation question

Oyin- Have you tried the calcs Jennifer suggested? If not, try those calcs to see if they work else let us know.