This content has been marked as final. Show 2 replies
I have a field I'm pulling in from excel, 'Group No':
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'?