Skip to main content
Question

Formula Help

  • January 27, 2018
  • 0 replies
  • 24 views
I am trying to write a formula for a new field.

If [ships in 7 days] a formula field is "yes", then display the number in [pallets outbound]
if not, display 0.


here's what I have -- not sure why I am getting an error.


If([Ships within 7 days?] = "yes", [Pallets Outbound],"0")
      This topic has been closed for replies.

      In suspect that this is a formula numeric field and you are trying to populate text into it.

      Try this as I removed the quotes

      If([Ships within 7 days?] = "yes", [Pallets Outbound],0)
      • ChrisChris
      • Registered
      • January 27, 2018
      The 0 should not be within quotes. Also what data type is [Ships within 7 days] ? If it's a check box then the value would be true. if([Ships within 7 days]=true, [pallets outbound],0) 
      • anomDiebolt
      • Registered
      • January 27, 2018
      How about this:

      If([Ships within 7 days?] = "yes", ToString([Pallets Outbound]), "0")
      Terms & ConditionsAccessibility statement