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

    LOD calculation question

    Oyin T-O

      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?