int(mid([revenue],2,2))*1000000, assuming that they are all double digit millions
int(rtrim(mid([revenue],2,2)))*1000000 if they are just single or double
or more comprehensive, always assuming the million and $ appear and spacing is the same
int(mid([revenue],2,len([revenue)-9])))*1000000 for a catch all
Dan! Welcome to the forums!
Sup T...hope all is going well in Tableau land! Happy user over here at Amazon!
Alex, I am getting an error that Len is being called a float. Should the -9 be contained within the revenue reference?