1 Reply Latest reply on Jul 1, 2017 8:52 PM by Akhilesh Singh

    Calculation results as Integer or String

    Morgan DUARTE

      Hi there,

       

      I would like to do a simple formula like this:

      IF Target<Actual THEN Target-Actual ELSE "Passed" END

       

      But this means I need to mix integer and string, which doesn't work.

      Any idea how to do it? May be with formatting?

       

      Thank you