Forum Discussion

kivanct's avatar
kivanct
Icon for Helper I rankHelper I
3 years ago

'MID' has the wrong data type or has an invalid value

Hi, It is a very long formula but I would be grateful if you could help me. I am receiving " 'MID' has the wrong data type or has an invalid value" error. How can i fix that ?          ...
Need Help
Show and Tell
Tips and Tricks
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
3 years ago

kivanct 

My guess is that the 2nd part of your MID formula "IndexOfSecondSpace - IndexOfFirstSpace - 2" is returning a negative of a blank in some cases.  For testing, try making 3 mesures.

  1. that returns  IndexOfFirstSpace
  2. that returns  IndexOfSecondSpace
  3. that retuturns  IndexOfSecondSpace - IndexOfFirstSpace - 2

and see what the result of those values is.