7 Replies Latest reply on Oct 5, 2018 9:47 AM by Chad Ritchie

    String as a Measure Value?

    Chad Ritchie

      Hi All,

       

      I'm reaching out to know if there is a workaround to get a calculated field as a measure value (want the ability to have this as the last column in a table). This calculated field may output alphabetic results or numeric results depending on an IF statement (such as the simplified example below).

       

      IF [dimension] = "sample"

      THEN "ABC"

      ELSE str([measure])

       

      Currently, my calculated field is a Measure of type "String" and I have converted all outputs to be strings using the str() function. There are no issues adding this to the Rows shelf, but when I drag into the Measure Values shelf, I get nulls for all records.

       

      Does anyone have any suggestions on how to accomplish getting this calculated field into the last column of a table?

       

      Best,

      Chad