我想获取数据集1中2.3.4.5列的最小值,用VALUE怎么写

我想获取数据集1中2.3.4.5列的最小值,用VALUE怎么写,有没有简便的写法。我是这样写的:MIN(GREPARRAY(value("1",2),item > 0),GREPARRAY(value("1",3),item > 0),GREPARRAY(value("1",4),item > 0),GREPARRAY(value("1",5),item > 0)) 1715746768860.jpg

FineReport 凡凡1 发布于 2024-5-15 12:19 (编辑于 2024-5-15 12:20)
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
Z4u3z1Lv6专家互助
发布于2024-5-15 12:25

什么数据库 用SQL处理

  • 凡凡1 凡凡1(提问者) SQL ,SQ和单元格都可以写,但是想用VALUE,看有没有办法。准备用在图表中 写Y轴底限
    2024-05-15 12:35 
  • Z4u3z1 Z4u3z1 回复 凡凡1(提问者) 单元格的话我这样处理:MIN(GREPARRAY(SPLIT(CONCATENATE(value(\"1\",2),\",\",value(\"1\",3),\",\",value(\"1\",4),\",\",value(\"1\",5)),\",\"),ITEM>0))
    2024-05-15 12:45 
最佳回答
0
帆软用户sj0gr13OMeLv0见习互助
发布于2024-5-15 13:31

https://www.bilibili.com/video/BV1e7421f7D2https://www.bilibili.com/video/BV1ts421P7kHhttps://www.bilibili.com/video/BV1Zw4m1S7nFhttps://www.bilibili.com/video/BV1PDMRe8EVehttps://www.bilibili.com/video/BV1oZ421x77Yhttps://www.bilibili.com/video/BV1Wf42117T2https://www.bilibili.com/video/BV1ox4y1p7vThttps://www.bilibili.com/video/BV1EU411f7sdhttps://www.bilibili.com/video/BV1KH4y137adhttps://www.bilibili.com/video/BV1A1421B7jqhttps://www.bilibili.com/video/BV1BJMRePEr6https://www.bilibili.com/video/BV1wjMRedEwLhttps://www.bilibili.com/video/BV1pEMRebE87https://www.bilibili.com/video/BV1hJMReaEVuhttps://www.bilibili.com/video/BV177MReaEichttps://www.bilibili.com/video/BV1x7MReKEXkhttps://www.bilibili.com/video/BV1CjMRefEJ8https://www.bilibili.com/video/BV117MReUEekhttps://www.bilibili.com/video/BV1Zr421L7Ckhttps://www.bilibili.com/video/BV13HMReUEFThttps://www.bilibili.com/video/BV1NHMRevEvXhttps://www.bilibili.com/video/BV1TpMRetEXxhttps://www.bilibili.com/video/BV16pMReuEVNhttps://www.bilibili.com/video/BV1SnMReLESAhttps://www.bilibili.com/video/BV16nMReBE3fhttps://www.bilibili.com/video/BV15GMReRE2uhttps://www.bilibili.com/video/BV1qb421B7Rkhttps://www.bilibili.com/video/BV1dy411Y7hdhttps://www.bilibili.com/video/BV1Kf42117Gqhttps://www.bilibili.com/video/BV1Cs421A7tKhttps://www.bilibili.com/video/BV1wz42127eBhttps://www.bilibili.com/video/BV1dH4y1g7vrhttps://www.bilibili.com/video/BV15x4y1W73mhttps://www.bilibili.com/video/BV1aZ421x7byhttps://www.bilibili.com/video/BV1sz42117sxhttps://www.bilibili.com/video/BV1d1421q7Fzhttps://www.bilibili.com/video/BV1i7421f7SGhttps://www.bilibili.com/video/BV1Ai421D765https://www.bilibili.com/video/BV1ST421D7Gzhttps://www.bilibili.com/video/BV1jt421M7hUhttps://www.bilibili.com/video/BV1SZ421x7f7https://www.douyin.com/note/7369056169555545378https://www.douyin.com/note/7369056393174830371https://www.douyin.com/note/7369056537785961762https://www.douyin.com/note/7369065692022328616https://www.douyin.com/note/7369065061286972687https://www.bilibili.com/video/BV1HH4y137Qqhttps://www.bilibili.com/video/BV1qJ4m1N76Ehttps://www.bilibili.com/video/BV1ds421A7Q9https://www.bilibili.com/video/BV1cb42187Mihttps://www.bilibili.com/video/BV1Fx4y1W7Rphttps://www.bilibili.com/video/BV1hU411f7tnhttps://www.bilibili.com/video/BV1Pm421g7ZDhttps://www.bilibili.com/video/BV17Z42147JDhttps://www.bilibili.com/video/BV1zJ4m1A77Ahttps://www.bilibili.com/video/BV16b421b72Ghttps://www.bilibili.com/video/BV1QT421D7i5https://www.bilibili.com/video/BV1jz42127m5https://www.bilibili.com/video/BV1sy411Y7Njhttps://www.bilibili.com/video/BV1Pb42187Hrhttps://www.bilibili.com/video/BV1Ry411Y71yhttps://www.bilibili.com/video/BV1tT421U78phttps://www.bilibili.com/video/BV1YZ421x7uahttps://www.bilibili.com/video/BV1Hi421X7iQhttps://www.bilibili.com/video/BV1Pw4m1X7j6https://www.bilibili.com/video/BV13H4y137pEhttps://www.bilibili.com/video/BV1JC41177Qghttps://www.bilibili.com/video/BV1cWMRekEDqhttps://www.bilibili.com/video/BV1atMRe9E4yhttps://www.bilibili.com/video/BV1FtMRe4EoNhttps://www.bilibili.com/video/BV1J7421f7sZhttps://www.bilibili.com/video/BV1JE421G78Zhttps://www.bilibili.com/video/BV1Vt421M79Bhttps://www.bilibili.com/video/BV1oD421A7KNhttps://www.bilibili.com/video/BV1mJ4m1N7Twhttps://www.bilibili.com/video/BV1Lt421M7ZRhttps://www.bilibili.com/video/BV1wt421u7a4https://www.bilibili.com/video/BV1oE42137hUhttps://www.bilibili.com/video/BV1vU411o7E3https://www.bilibili.com/video/BV1at421M7GFhttps://www.bilibili.com/video/BV1Ms421P7x3https://www.bilibili.com/video/BV1AD421P7Z8https://www.bilibili.com/video/BV1Rs421c7puhttps://www.bilibili.com/video/BV1bt421M7WRhttps://www.bilibili.com/video/BV1hy411Y7FEhttps://www.bilibili.com/video/BV1Bb421B7aPhttps://www.bilibili.com/video/BV16t421M7Fehttps://www.bilibili.com/video/BV14r421j7Ndhttps://www.bilibili.com/video/BV1mt421M7fzhttps://www.bilibili.com/video/BV1TE421G7zVhttps://www.bilibili.com/video/BV1Cb421B7v2https://www.bilibili.com/video/BV1Dx4y1i7vRhttps://www.bilibili.com/video/BV1WM4m1C7aVhttps://www.bilibili.com/video/BV1Dy411Y7yXhttps://www.bilibili.com/video/BV1V7421f75Chttps://www.bilibili.com/video/BV111421q73yhttps://www.bilibili.com/video/BV1Fb42187FMhttps://www.bilibili.com/video/BV1vf42117Ughttps://www.bilibili.com/video/BV1LT421D7C1https://www.bilibili.com/video/BV1Fs421w7p2https://www.bilibili.com/video/BV187421f7XJhttps://www.bilibili.com/video/BV15H4y137LLhttps://www.bilibili.com/video/BV1Ai421D7Nhhttps://www.bilibili.com/video/BV1FT421Q7Dghttps://www.bilibili.com/video/BV1Pw4m1X7hfhttps://www.bilibili.com/video/BV1ED421G7vzhttps://www.bilibili.com/video/BV1Kx4y1W73Zhttps://www.bilibili.com/video/BV1bZ42147y1https://www.bilibili.com/video/BV1bz421178yhttps://www.bilibili.com/video/BV1Zy411Y7JYhttps://www.bilibili.com/video/BV1eC41177Vthttps://www.bilibili.com/video/BV1tz42117LJhttps://www.bilibili.com/video/BV13m421M7Wxhttps://www.bilibili.com/video/BV1nt421M781https://www.bilibili.com/video/BV1E1421q73Fhttps://www.bilibili.com/video/BV1eZ42147Tfhttps://www.bilibili.com/video/BV1jw4m1X7JXhttps://www.bilibili.com/video/BV19J4m1A7qbhttps://www.bilibili.com/video/BV1Dw4m1Q7pk

  • 2关注人数
  • 208浏览人数
  • 最后回答于:2024-5-15 13:31
    请选择关闭问题的原因
    确定 取消
    返回顶部