2 Replies Latest reply on Aug 28, 2018 12:04 PM by Jim Dehner

    STR(ROUND([Spot Cad],2)) + "$" is not showing the desired result

    Sudesh Kumar Rambaccussing

      Hi,

       

      I'm using the following calculated filed in order to show in the following format:

       

      1,31 $1,49 $1,67 $84,47 ¥0,96 $

       

      if [Cur Cd] ='JPY' THEN STR(ROUND( (1/[Spot Cad]),2)) + "¥"

      ELSEIF [Cur Cd] ='USD' THEN  STR(ROUND([Spot Cad],2)) + "$"

      ELSE  STR(ROUND([Spot Cad],2)) + "$"  END

       

      However the result show in tableau is as follows

       

      Any help will be greatly appreciated.