title: Creating a formula to display "Y" if either one of 2 fields has a 'YES' in it
body: <p>I have tried 2 formulas to get a "Y" on my report if one of two fields has a value of YES but I cannot get the formula to work.</p>
  
  <p>Formula 1:
  if ({Print.RetailRx} = "YES")
  or ({Print.MailRx} = "YES")
  then "Y"
  Else ""</p>
  
  <p>Formula 2:
  if ({Print.RetailRx} = "YES") then "Y"
  else if ({Print.MailRx} = "YES")
  then "Y"</p>
  
  <p>What happens is if retailRx has a value of "YES" I'll get the "Y" but it does not apply for MailRx.  Can anyone help?  Thanks</p>