none
Converting a string to a numeric value in PWA RRS feed

  • Question

  • Hopefully an easy question. We created page in PWA that scores dependency impacts by platform. The response value is a string....like 'None' or 'Low'... If there is a formula that converts a string to a numeric value in PWA that we can use our custom field, please let me know. Thank you.
    Wednesday, May 9, 2018 11:19 PM

Answers

  • M Scott Davis,

    I don't use PWA but there is no ready made formula for converting text to a numeric value, unless the text is a date. You need to define what numeric value represents "none", what numeric value represents "low" and so forth. In a custom field you can then use a nested IF statement, a Choose, or a Switch function to translate the text to a number.

    Hope this helps.

    John

    Friday, May 11, 2018 4:27 PM