可能是一个bug

问答  收藏
3 / 71

结构:
只有两个字段
文本格式:数量
数字格式:计算
其中计算的默认值为函数计算

目的:
若“数量”字段包含“-”符号,则调用 FIND 取上下限,RANDBETWEEN 取其中间随机值;否则直接返回

过程:
IF(INCLUDE(数量,"-"),RANDBETWEEN(1,2),数量)——正常

IF(INCLUDE(数量,"-"),RANDBETWEEN(FIND(数量,"","-"),10),数量)——无-正常,有-正常

IF(INCLUDE(数量,"-"),RANDBETWEEN(10,FIND(数量,"-","")),数量)——无-正常,有-错误

IF(INCLUDE(数量,"-"),RANDBETWEEN(FIND(数量,"","-"),FIND(数量,"-","")),数量)——无-正常,有-错误

私有部署,版本 6.5.3