• 
  两个数据集用共同字段去关联？

  data数据集中的部门和MDYHZQ数据集有共同的字段ZICZS0000，如何在“要货周期”单元格，取到DAYS的值 ？    （不用在语句中用inner join关联的方式） 记得帆软里有个过滤功能把？

  250个浏览 3个回答 2023年10月12日发布
• 
  预览时出现报错，原因是什么呢？

  SELECT ${sel_col} FROM "_SYS_BIC"."CB.AL.YW/ZAL_STOCK_BQPRICE"(PLACEHOLDER."$$ZIP_STDATE$$"=>${user_date_from}   --查询开始日期,PLACEHOLDER."$$ZIP_ENDDATE$$"=>${user_date_to}) A LEFT JOIN(select (CASE WHEN ZICYY0313 IS NOT NULL THEN ZICYY0313 ELSE '未做标记单' END ) ZICYY0313,(CASE WHEN ZICYY3030 IS NOT NULL THEN ZICYY3030      WHEN ZICYY3030 IS NULL THEN '无货位'END ) ZICYY3030,ZICZS0000 BM,ZICZB0000 PCfrom "_SYS_BIC"."CB.AL.YW/ZAL_STOCK_BQPRICEJGFDS_KWBS"(PLACEHOLDER."$$ZIP_STDATE$$"=>${user_date_from}   --查询开始日期,PLACEHOLDER."$$ZIP_ENDDATE$$"=>${user_date_to})  -- 当前日期 ) G ON A.ZICZS0000=G.BM AND A.ZICZB0000=G.PC LEFT JOIN  "_SYS_BIC"."CB.BL.YW/ZBL_ZDEMM012" B ON  A.ZICZS0000=B.ZICZS0000 AND A.ZICZB0000=B.ZICZB0000 LEFT JOIN(SELECT COMP_CODE,ZICZB0000,ZICZA0000,ZICKA0012 AS GSRKRQ FROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDEMM013" ) C ON  A.COMP_CODE=C.COMP_CODE  AND A.ZICZB0000=C.ZICZB0000 AND A.ZICZA0000=C.ZICZA0000WHERE 1=1 -- A.ZICZA0003 <> '1110' AND -- 不取旧饰   AND A.ZJS_TO<>0  AND LENGTH(A.ZICZB0000)>0  AND LENGTH(A.ZICZB0001)>0  AND A.ZJS_TO <>'0.001'${user_ziczs0000_auth} --部门(含权限)${user_zicza0004} --商品大类${user_zicza0015} --品种ORDER BY ${sel_col}

  199个浏览 3个回答 2023年10月12日发布
• 
  如何根据陈列数量的数值来显示不同的比例值呢?

  J列“上限比例”如何根据陈列数量的数值来显示不同的比例值呢?除了写公式：IF(I4>=3000, "35%", IF(I4>=2500, "45%", IF(I4>=2000, "50%", IF(I4>=1500, "55%", IF(I4>=1000, "60%", IF(I4>=800, "65%", IF(I4>=600, "70%", IF(I4>=400, "75%", IF(I4>=300, "80%", IF(I4>=200, "90%", IF(I4>=150, "100%", IF(I4>=100, "110%", "120%"))))))))))))或者switch("true",i4>=3000,"35%",i4>=2500,"45%",i4>=2000,"50%",i4>=1500,"55%",i4>=1000,"60%",i4>=800,"65%",i4>=600,"70%",i4>=400,"75%",i4>=300,"80%",i4>=200,"90%",i4>=150,"100%",i4>=100,"110%",i4<100,"120%")还有其他方式么？写完感觉公式太长了 。能否做成配置表类型的？左图是配置表，右图是J列根据I列的值显示不同的上限比例

  170个浏览 3个回答 2023年10月12日发布
• 
  查询结果与后台数据不匹配

  后台原始数据：报表查询结果：  每一个单据编号后面都会跟所有数据，以此类推：填报属性：查询界面：

  175个浏览 2个回答 2023年09月20日发布
• 
  当月剩余天数怎么计算？

  想根据月计划和月累计销售，除以“月剩余天数”来计算出每天所需的销售额。。

  235个浏览 2个回答 2023年09月18日发布
• 
  单元格怎么取FTP服务器存放的图片

         填报报表在提交时会把图片上传到FTP服务器里。  但在查询表里怎么把对应的图片显示出来呢？  插入超链接么？ 

  257个浏览 1个回答 2023年09月11日发布
• 
  为啥会查出两条数据。。。《实际完成总销售》里的33300不知道怎么出来的。。单用语句查就无问题

  1： 用语句跑就是一条数据：2：用报表就会多一条33300的数据， 不知道咋出来的

  307个浏览 3个回答 2023年09月01日发布
• 
  语句报错，看不出问题来：

  报错信息为：inserted value too large for column: search table error:  value conversion failed;exception 70004013: cannot convert "100" to the type VARCHAR(2) for column PM,Exception in executor plan337098564@hanaphn01原语句：原语句.zipSELECT A.*,B.DTXS,A.TB-1 AS TBZF,A.HB-1 AS HBZF,TB.TBSJXSJS,HB.HBSJXSJS,DY.SJXSJS,QN.QNSJXSJE ,JN.JNSJXSJE FROM (SELECT * FROM "_SYS_BIC"."CB.AL.YW/ZAL_BMYXSJDB"(PLACEHOLDER."$$CALMONTH$$"=>'202308',PLACEHOLDER."$$CALDAY$$"=>'20230813')WHERE 1=1 --AND ZICZS0000 IN (${GET_ZICZS0000}) ) ALEFT JOIN (SELECT ZICZS0000,SUM(SJXSJE) AS DTXS FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJEFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALDAY='20230813'  AND A.ZICZS0008<>'8009194' --屏蔽大客户) GROUP BY ZICZS0000) B ON A.ZICZS0000=B.ZICZS0000 LEFT JOIN  ( SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS TBSJXSJS FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJSFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALMONTH='20220813'  AND A.ZICZS0008<>'8009194' --屏蔽大客户) GROUP BY ZICZS0000,YF  ) TB ON A.ZICZS0000=TB.ZICZS0000 LEFT JOIN  (  SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS HBSJXSJS FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJSFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALMONTH='20230713'  AND A.ZICZS0008<>'8009194' --屏蔽大客户)GROUP BY ZICZS0000,YF  ) HB ON A.ZICZS0000=HB.ZICZS0000   LEFT JOIN  (  SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS SJXSJS FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJSFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALMONTH='202308'  AND A.ZICZS0008<>'8009194' --屏蔽大客户)GROUP BY ZICZS0000,YF  ) DY ON A.ZICZS0000=DY.ZICZS0000 LEFT JOIN  (  SELECT ZICZS0000,SUM(SJXSJE) AS QNSJXSJE FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJEFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALYEAR='2022' AND A.CALDAY<='20220813'  AND A.ZICZS0008<>'8009194')GROUP BY ZICZS0000  ) QN ON A.ZICZS0000=QN.ZICZS0000     LEFT JOIN  (  SELECT ZICZS0000,SUM(SJXSJE) AS JNSJXSJE FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJEFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALYEAR='2023'  AND A.CALDAY<='20230813' AND A.ZICZS0008<>'8009194')GROUP BY ZICZS0000 ) JN ON A.ZICZS0000=JN.ZICZS0000 WHERE  JN.JNSJXSJE<>0 OR A.ZIFYY0801>0ORDER BY A.ZICZS0000

  300个浏览 3个回答 2023年08月14日发布
• 
  H3 公式问题

  为啥G3=00:00时，公式没有显示成“没刷卡”啊

  177个浏览 2个回答 2023年08月07日发布
• 
  帆软里，字段ZDGSJ1_1的内容固定为六位数字，如何只取前4位并且在第二位和第三位之间增加一个冒号

  帆软里，字段ZDGSJ1_1的内容固定为六位数字，如何只取前4位并且在第二位和第三位之间增加一个冒号 ?

  180个浏览 2个回答 2023年08月07日发布

334

42

334

10