7 Replies Latest reply on Feb 15, 2012 11:47 AM by . Mar

    scientific( E)  notation for $ ( large number)..., how to show the full number?

    . Mar

      Hello,

       

      I have a custom label in a  pie chart :

      max([SavingsTypeGroup])+ "

      "+" $"+Str(SUM([Savings]))

       

      Tableau displays a long number  in scientific e notation . Also, I lam loosing decimal parts of numbers..

      If I just put the money field on the Label shelf, the numbers show just fine ( with decimals and without the e notation)

       

      is there a way to reformat the custom label so that it shows a  full number ? ( i tried Str(round(SUM([Savings]),2) -- that didn't work...)

       

      Thanks

       

      I attached 2 screenshots one-with the custom label  and another one and with the number field on the Label shelf