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
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi kivanct 

 

You have used MID in the 11 variables _xxxxxMDASY and any variable will use the previous variable's result. If one variable cannot return the correct result, it will affect the following variables. You can return the results of variables one by one from the first variable to find out from which one it returns this error. Then correct the formula from then on. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!