2 Replies Latest reply: May 12, 2016 9:51 AM by Thirumala Dandamudi RSS

    Null / Blanks in Excel Import

    Diane Nicholls



      I have a field I'm pulling in from excel, 'Group No':


           Upper(if([Group No]=0,'GR-000000',

           if([Group No]='','GR-000000',[Group No]))) As [Group No],


      The problem is, that if the field is blank in excel, I want to populate it with 'GR-000000'.


      I've tried '', as you can see from above, with no luck.


      Its producing a line in my pivot table with a - where the GR number should be.

      How can I replace any 'blanks' with 'GR-000000'?