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?
IF ATTR([PartnerID] )<> 'XX' THEN COUNT( [PolicyNumber])
IF ATTR([PartnerID]) = 'PL' AND ATTR( [Policy Summary] )= 'BUNDLE' THEN 2* COUNT([Coverage Id]) END