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

    Null / Blanks in Excel Import

    Diane Nicholls

      Hi,

       

      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'?


      Thanks


      Di