Forum Discussion
Relationship with Unique Value
I am trying to create a relationship between two tables. I have tried to do this and I have been receiving the error "cant create a relationship between these two columns because one of the columns m...
Anonymous,
Enclose 1 with double quotes (").
Column = IF ( [Master Column] = "", "1", [Master Column] )
I have one row that contains a blank value, How would I go about padding this with a 1? I have tried to just create a new column by using:
=if([Master Column]="",1,[Master Column].
With this I am recieving an "Expressions that yield a varient data-type cannot be used to define calculated columns" error.
vanessafvg
Community Champion
Community ChampionAnonymous IF ( ISBLANK ( [Master Column] ), 1, [Master Column] )
The formula returns the same error that I was returned previously for me.
v-chuncz-msftCommunity Support
Anonymous,
Enclose 1 with double quotes (").
Column = IF ( [Master Column] = "", "1", [Master Column] )
Thank you that one works for me!