Discussions

Expand all | Collapse all

Formula error: Expecting text but found number in numeric reference formula field

  • 1.  Formula error: Expecting text but found number in numeric reference formula field

    Posted 05-13-2019 16:49
    I have a numeric reference field with the following formula:

    [Pharmacy / Drug Shipping - Record ID#]

    And I'm receiving an error with the entire formula underlined in red stating "Expecting text but found number".  The number is correct; why is it expecting text?


  • 2.  RE: Formula error: Expecting text but found number in numeric reference formula field

    Bronze
    Contributor
    Posted 05-13-2019 17:05
    Is your field type formula-numeric? Sounds like the error you would receive if the formula you have is text? Does wrapping it in a toText() resolve it?

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base


  • 3.  RE: Formula error: Expecting text but found number in numeric reference formula field

    Posted 05-13-2019 17:24
    If the formula does save OK  and you are just referring to the yellow triangle warning in the formula editor, sometimes that formula editor is not 100% correct in its warnings, ie it may be a false alarm.