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

    Conditional Count Calculation

    Simon Philipose



      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?