8 Replies Latest reply on Jan 10, 2019 3:29 PM by Peter Fakan

    Setting dynamic datatype for fields

    Anjali Sn

      I have a calcualed field as follows called Datatype_calc:

       

      IF [Data_Type] = 'Percent'

      THEN

      "%"

      END

       

      This basically returns a '%' if the Data_Type column has 'Percent' as its value. Next, I put [Sales] & [Datatype_calc] on the text marks card as follows: <Sales><Datatype_calc> which gives me values like 20.00%, 100.00% etc. But, there are some cases when the value in the [Sales] field is empty, in this case, I'm just getting the '%', something like this:

       

      Screen Shot 2019-01-09 at 5.20.56 PM.png

       

      But, in these cases I don't even want the % to show, it should just be empty. How do I do that?