Bug or not?

[Anonymous]

Version = SWITCH(

TRUE(),

( SEARCH("7", default[Flowsheet],,0) > 0), MID("7",1,5),

( SEARCH("8", default[Flowsheet],,0) > 0), "My folder", "Ohter software")

Too few arguments were passed to the MID function. The minimum argument count for the function is 3.

[az38]

Hi @Anonymous 

looks like bug with the locale. 

im using ";" not "," as delimiter and for its working good

mid("7";1;5)

bytheway, why dont you use LEFT function if you are trying to get first 5 symbols?

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous · Accepted solution]

I fixed this by using double commas

MID(default[Flowsheet],9,,5)