1 Reply Latest reply on Oct 12, 2018 11:58 AM by Deepak Rai

    Conditional Count Calculation

    Simon Philipose

      Hi,

       

      So I am trying to create a count of policies, but there is one type of policy that needs to be counted twice. I have two separate calculations that work, but am having trouble writing a calculation that tells Tableau to calculate one or the other.

       

      COUNT (IF [PartnerID] <> 'XX' THEN [PolicyNumber] END)

       

      COUNT (IF [PartnerID] = 'PL' AND [Policy Summary] = 'BUNDLE' THEN [Coverage Id] END) * 2

       

      Anyone have any idea how I could combine these two into one conditional calculation?

       

      Thanks!