Forum Discussion
DouweMeer
Impactful Individual
Impactful IndividualExpressions that yield variant data type cannot be used
I created a logic to combine a product description from multiple excel files. At one point it started giving me a data variant error so I was looking for numbers in my expression. I was unable to fin...
amitchandak
Super User
Super UserDouweMeer , With data type text and blank(), it should not give this. Try to move a6 as first and try.
I tried this and it worked
Measure = VAR A1 = blank()
VAR A2= blank()
VAR A3 = blank()
VAR A4 = 4
return switch(True() ,
A1<> BLANK(),A1 ,
A2<> BLANK(),A2 ,
A3<> BLANK(),A3 ,
A4<> BLANK(),A4
)
DouweMeer