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.

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

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