cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dkehoe32 Regular Visitor
Regular Visitor

LOOKUPVALUE doesnt support values of type integer with type text

Im using the LOOKUPVALUE function in order to fill this column but i keep getting this error.forum 3.PNG

7 REPLIES 7
luxpbi Member
Member

Re: LOOKUPVALUE doesnt support values of type integer with type text

Hi dkehoe32,

 

This is beacause one value is type text and the other is type int. What is the type of [Material]? If the change doen't afect your report, please consider to change the data type yo number and try again.

dkehoe32 Regular Visitor
Regular Visitor

Re: LOOKUPVALUE doesnt support values of type integer with type text

the material is a number code but BI says its in text format and im unable to change it to number

luxpbi Member
Member

Re: LOOKUPVALUE doesnt support values of type integer with type text

Can you please send a photo of the material data type? 

 

Captura3.PNG

dkehoe32 Regular Visitor
Regular Visitor

Re: LOOKUPVALUE doesnt support values of type integer with type text

jason.PNGmaterial.PNGproduct code.PNG                                        

These are the 3 values for my LOOKUPVALUE and their data types

luxpbi Member
Member

Re: LOOKUPVALUE doesnt support values of type integer with type text

Change this to a data type number: 

 

Captura.PNG

dkehoe32 Regular Visitor
Regular Visitor

Re: LOOKUPVALUE doesnt support values of type integer with type text

It doesnt allow that

Highlighted
luxpbi Member
Member

Re: LOOKUPVALUE doesnt support values of type integer with type text

Then I think that the problem is that you have in your [Material] Column data with both types, text and int.