1 Reply Latest reply on Oct 26, 2018 10:42 AM by Deepak Rai

    Returning Text from Calculated Field

    Jacob Seymer

      Hello,

      I have trouble when trying to make a calculation that will return text. It returns numbers just fine, but always returns #error when I change the return to any text. Is this not supported?

      Simple examples would be creating a blank calculated field to return "test" in all cases.

       

      My specific problem is that I want to split up the recieved date from the hour 4 into 4:00 to 4:30 and 4:30 to 5, but it doesn't let me return 4.5 or 4:30 as it is text:

       

      IF (DATEPART('hour', [RECEIVED_DT]) == 16 AND DATEPART('minute', [RECEIVED_DT]) < 30 )

      THEN STR"4.5"

      ELSEIF (DATEPART('hour', [RECEIVED_DT]) == 16 AND DATEPART('minute', [RECEIVED_DT]) >= 30 )

      THEN STR("60")

      ELSE

      STR(DATEPART('hour', [RECEIVED_DT]))

      END

       

      60 returns fine but not 4.5

       

      Thank you for any suggestions