8 Replies Latest reply: Jan 30, 2012 6:52 AM by cdettmer RSS

    Text and numeric value in one table

      Hi everyone,

       

      I'm trying to format a straight table with numbers and text in it. Unfortunately, it doesn't show the text only " - ", the numbers work fine though.

       

      This is my code:

      =IF([Customer.Year Value 2011]>1,Num([Customer.Year Value 2011],'#.###,#'),

      If([Customer.Year Value 2011]<1,Num([Customer.Year Value 2011],'###,#%'),

      text([Customer.Year Value 2011])))                      --> this is not working

       

      Many thanks!!