Casting string to integer

[Hockeyman9474]

I am extracing a number from a text string and need to convert it to integer so that I can compare it in a filter. It appears as though @int is the way to go but I am having trouble figuring out how to format. Here is what the filter looks like before it's casted:

Filter(dailySales,Mid(Retailer,9,1)=ThisItem.Result))

the number being extracted from the Retailer column is bewteen 1 and 6 and thisitem.result is definately a number because I have checked this.

[AndyPennell · Accepted solution]

Use the Value function to turn a string into a number. (PA makes no distinction betweeen doubles and integers). So if I understand your example:

Filter(dailySales,Value(Mid(Retailer,9.1))=ThisItem.Result))

[Hockeyman9474]

actually figured that out on my own, but yes value worked...thanks