6 Replies Latest reply: Apr 21, 2014 8:59 AM by Ashfaq Mohammed RSS

    Text To Number



      When my report is exported to excel, certain columns are in text format. I tried to change them to number format by using NUM function and Number Tab. After using both the things, this is not getting converted to number. I used following expression in my sheet object(Pivot table) .


      =num(Count ({ $ <[Deleted] = {'No'} > } DISTINCT [Key]))


      Kindly suggest me any ideas.