• 
  公式问题

  L44*VLOOKUP($H44,$H$1:$T$3,$L$4,FALSE)/VLOOKUP($H44,$H$1:$T$3,$J$4,FALSE)-J44这种公式怎么在FR里实现

  27个浏览 2个回答 2025年09月29日发布
• 
  跨sheet公式问题

  在新sheet里，对两个sheet数据做除法：结果存在无穷大，怎么处理

  19个浏览 1个回答 2025年09月28日发布
• 
  筛选框所选内容提示sql注入

  18个浏览 1个回答 2025年09月26日发布
• 
  FR工具界面的鼠标大小可以调吗

   

  27个浏览 1个回答 2025年09月25日发布
• 
  sql数据关联问题

  字段u2至x4没有值，可能什么原因：SELECT     r.b AS b1,    r.c AS c1,    r.d AS d1,    r.e AS e1,    r.f AS f1,    r.g AS g1,    r.h AS h1,    r.i AS i1,    r.j AS j1,    r.k AS k1,    r.l AS l1,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.lfy_actual_ytd_display ELSE a.lfy_actual_ytd_display END        ELSE NULL     END AS u2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_budget_ytd_display ELSE a.cfy_budget_ytd_display END        ELSE NULL     END AS v2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_f1_ytd_display ELSE a.cfy_f1_ytd_display END        ELSE NULL     END AS w2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_f2_ytd_display ELSE a.cfy_f2_ytd_display END        ELSE NULL     END AS x2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.nfy_budget_ytd_display ELSE a.nfy_budget_ytd_display END        ELSE NULL     END AS z2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.ly_actual_mtd_display ELSE a.ly_actual_mtd_display END        ELSE NULL     END AS o3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_budget_mtd_display ELSE a.cy_budget_mtd_display END        ELSE NULL     END AS p3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_actual_mtd_display ELSE a.cy_actual_mtd_display END        ELSE NULL     END AS q3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.ly_actual_ytd_display ELSE a.ly_actual_ytd_display END        ELSE NULL     END AS o4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_budget_ytd_display ELSE a.cy_budget_ytd_display END        ELSE NULL     END AS p4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_actual_ytd_display ELSE a.cy_actual_ytd_display END        ELSE NULL     END AS q4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf1_lfyact_fullyear_display ELSE a.cal_contvar_cfyf1_lfyact_fullyear_display END        ELSE NULL     END AS ai2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf1_cfybud_fullyear_display ELSE a.cal_contvar_cfyf1_cfybud_fullyear_display END        ELSE NULL     END AS aj2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_lfyact_fullyear_display ELSE a.cal_contvar_cfyf2_lfyact_fullyear_display END        ELSE NULL     END AS ak2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_cfybud_fullyear_display ELSE a.cal_contvar_cfyf2_cfybud_fullyear_display END        ELSE NULL     END AS al2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_cfyf1_fullyear_display ELSE a.cal_contvar_cfyf2_cfyf1_fullyear_display END        ELSE NULL     END AS am2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_nfybud_cfyf2_fullyear_display ELSE a.cal_contvar_nfybud_cfyf2_fullyear_display END        ELSE NULL     END AS aq2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfybud_lfybud_fullyear_display ELSE a.cal_contvar_cfybud_lfybud_fullyear_display END        ELSE NULL     END AS ar2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_lyact_mtd_display ELSE a.cal_contvar_cyact_lyact_mtd_display END        ELSE NULL     END AS w3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_cybud_mtd_display ELSE a.cal_contvar_cyact_cybud_mtd_display END        ELSE NULL     END AS x3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_lyact_ytd_display ELSE a.cal_contvar_cyact_lyact_ytd_display END        ELSE NULL     END AS w4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_cybud_ytd_display ELSE a.cal_contvar_cyact_cybud_ytd_display END        ELSE NULL     END AS x4FROM raw_finerpt_config_vprpt_displaysetting r LEFT JOIN apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis a     ON a.vmr_code_entity = r.c     AND a.vmr_code_kfi = 'Vec_15'    AND a.cy_cal_vmr_datep_yyyy_mm_str = '${ymonth}'    AND a.vmr_type_data = '${vmr_type_data}'    AND a.config_accesscode LIKE '%${config_accesscode}%'    AND a.type_displaycurr = '${type_displaycurr}'    AND a.cmentity_type_buzunit = '${cmentity_type_buzunit}'LEFT JOIN (    SELECT        t1.cmentity_type_buzunit,        t1.vmr_type_data,        t1.type_displaycurr,        t1.cy_cal_vmr_datep_yyyy_mm_str,        SUM(t1.lfy_actual_ytd_display) AS lfy_actual_ytd_display,        SUM(t1.cfy_budget_ytd_display) AS cfy_budget_ytd_display,        SUM(t1.cfy_f1_ytd_display) AS cfy_f1_ytd_display,        SUM(t1.cfy_f2_ytd_display) AS cfy_f2_ytd_display,        SUM(t1.nfy_budget_ytd_display) AS nfy_budget_ytd_display,        SUM(t1.ly_actual_mtd_display) AS ly_actual_mtd_display,        SUM(t1.cy_budget_mtd_display) AS cy_budget_mtd_display,        SUM(t1.cy_actual_mtd_display) AS cy_actual_mtd_display,        SUM(t1.ly_actual_ytd_display) AS ly_actual_ytd_display,        SUM(t1.cy_budget_ytd_display) AS cy_budget_ytd_display,        SUM(t1.cy_actual_ytd_display) AS cy_actual_ytd_display,        SUM(t1.cal_contvar_cfyf1_lfyact_fullyear_display) AS cal_contvar_cfyf1_lfyact_fullyear_display,        SUM(t1.cal_contvar_cfyf1_cfybud_fullyear_display) AS cal_contvar_cfyf1_cfybud_fullyear_display,        SUM(t1.cal_contvar_cfyf2_lfyact_fullyear_display) AS cal_contvar_cfyf2_lfyact_fullyear_display,        SUM(t1.cal_contvar_cfyf2_cfybud_fullyear_display) AS cal_contvar_cfyf2_cfybud_fullyear_display,        SUM(t1.cal_contvar_cfyf2_cfyf1_fullyear_display) AS cal_contvar_cfyf2_cfyf1_fullyear_display,        SUM(t1.cal_contvar_nfybud_cfyf2_fullyear_display) AS cal_contvar_nfybud_cfyf2_fullyear_display,        SUM(t1.cal_contvar_cfybud_lfybud_fullyear_display) AS cal_contvar_cfybud_lfybud_fullyear_display,        SUM(t1.cal_contvar_cyact_lyact_mtd_display) AS cal_contvar_cyact_lyact_mtd_display,        SUM(t1.cal_contvar_cyact_cybud_mtd_display) AS cal_contvar_cyact_cybud_mtd_display,        SUM(t1.cal_contvar_cyact_lyact_ytd_display) AS cal_contvar_cyact_lyact_ytd_display,        SUM(t1.cal_contvar_cyact_cybud_ytd_display) AS cal_contvar_cyact_cybud_ytd_display    FROM apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis AS t1    WHERE (t1.vmr_code_kfi = 'Vec_11' AND t1.cmentity_type_buz <> 'Holding')        OR (t1.vmr_code_kfi = 'Vec_14' AND t1.cmentity_type_buz = 'Holding')    GROUP BY        t1.cmentity_type_buzunit,        t1.vmr_type_data,        t1.type_displaycurr,        t1.cy_cal_vmr_datep_yyyy_mm_str) b ON b.cmentity_type_buzunit = '${cmentity_type_buzunit}'    AND b.vmr_type_data = '${vmr_type_data}'    AND b.type_displaycurr = '${type_displaycurr}'    AND b.cy_cal_vmr_datep_yyyy_mm_str = '${ymonth}'WHERE r.k = 'Ctrl EBITDA'    AND r.j::text != '0'     AND r.year = LEFT('${ymonth}', 4)    AND (        (r.j::text != '2')         OR         (r.j::text = '2' AND r.b LIKE '%${config_accesscode}%')    )ORDER BY l1

  0个浏览 0个回答 2025年09月24日发布
• 
  数据表关联问题，特定字段值需要做关联重新取值

  u2至x4字段没值，可能是什么原因：SELECT     r.b AS b1,    r.c AS c1,    r.d AS d1,    r.e AS e1,    r.f AS f1,    r.g AS g1,    r.h AS h1,    r.i AS i1,    r.j AS j1,    r.k AS k1,    r.l AS l1,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.lfy_actual_ytd_display ELSE a.lfy_actual_ytd_display END        ELSE NULL     END AS u2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_budget_ytd_display ELSE a.cfy_budget_ytd_display END        ELSE NULL     END AS v2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_f1_ytd_display ELSE a.cfy_f1_ytd_display END        ELSE NULL     END AS w2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cfy_f2_ytd_display ELSE a.cfy_f2_ytd_display END        ELSE NULL     END AS x2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.nfy_budget_ytd_display ELSE a.nfy_budget_ytd_display END        ELSE NULL     END AS z2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.ly_actual_mtd_display ELSE a.ly_actual_mtd_display END        ELSE NULL     END AS o3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_budget_mtd_display ELSE a.cy_budget_mtd_display END        ELSE NULL     END AS p3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_actual_mtd_display ELSE a.cy_actual_mtd_display END        ELSE NULL     END AS q3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.ly_actual_ytd_display ELSE a.ly_actual_ytd_display END        ELSE NULL     END AS o4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_budget_ytd_display ELSE a.cy_budget_ytd_display END        ELSE NULL     END AS p4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cy_actual_ytd_display ELSE a.cy_actual_ytd_display END        ELSE NULL     END AS q4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf1_lfyact_fullyear_display ELSE a.cal_contvar_cfyf1_lfyact_fullyear_display END        ELSE NULL     END AS ai2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf1_cfybud_fullyear_display ELSE a.cal_contvar_cfyf1_cfybud_fullyear_display END        ELSE NULL     END AS aj2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_lfyact_fullyear_display ELSE a.cal_contvar_cfyf2_lfyact_fullyear_display END        ELSE NULL     END AS ak2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_cfybud_fullyear_display ELSE a.cal_contvar_cfyf2_cfybud_fullyear_display END        ELSE NULL     END AS al2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfyf2_cfyf1_fullyear_display ELSE a.cal_contvar_cfyf2_cfyf1_fullyear_display END        ELSE NULL     END AS am2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_nfybud_cfyf2_fullyear_display ELSE a.cal_contvar_nfybud_cfyf2_fullyear_display END        ELSE NULL     END AS aq2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cfybud_lfybud_fullyear_display ELSE a.cal_contvar_cfybud_lfybud_fullyear_display END        ELSE NULL     END AS ar2,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_lyact_mtd_display ELSE a.cal_contvar_cyact_lyact_mtd_display END        ELSE NULL     END AS w3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_cybud_mtd_display ELSE a.cal_contvar_cyact_cybud_mtd_display END        ELSE NULL     END AS x3,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_lyact_ytd_display ELSE a.cal_contvar_cyact_lyact_ytd_display END        ELSE NULL     END AS w4,    CASE         WHEN r.j::text != '2' THEN             CASE WHEN r.g = 'Non-allocated structure costs' THEN b.cal_contvar_cyact_cybud_ytd_display ELSE a.cal_contvar_cyact_cybud_ytd_display END        ELSE NULL     END AS x4FROM raw_finerpt_config_vprpt_displaysetting r LEFT JOIN apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis a     ON a.vmr_code_entity = r.c     AND a.vmr_code_kfi = 'Vec_15'    AND a.cy_cal_vmr_datep_yyyy_mm_str = '${ymonth}'    AND a.vmr_type_data = '${vmr_type_data}'    AND a.config_accesscode LIKE '%${config_accesscode}%'    AND a.type_displaycurr = '${type_displaycurr}'    AND a.cmentity_type_buzunit = '${cmentity_type_buzunit}'LEFT JOIN (    SELECT        t1.cmentity_type_buzunit,        t1.vmr_type_data,        t1.type_displaycurr,        t1.cy_cal_vmr_datep_yyyy_mm_str,        SUM(t1.lfy_actual_ytd_display) AS lfy_actual_ytd_display,        SUM(t1.cfy_budget_ytd_display) AS cfy_budget_ytd_display,        SUM(t1.cfy_f1_ytd_display) AS cfy_f1_ytd_display,        SUM(t1.cfy_f2_ytd_display) AS cfy_f2_ytd_display,        SUM(t1.nfy_budget_ytd_display) AS nfy_budget_ytd_display,        SUM(t1.ly_actual_mtd_display) AS ly_actual_mtd_display,        SUM(t1.cy_budget_mtd_display) AS cy_budget_mtd_display,        SUM(t1.cy_actual_mtd_display) AS cy_actual_mtd_display,        SUM(t1.ly_actual_ytd_display) AS ly_actual_ytd_display,        SUM(t1.cy_budget_ytd_display) AS cy_budget_ytd_display,        SUM(t1.cy_actual_ytd_display) AS cy_actual_ytd_display,        SUM(t1.cal_contvar_cfyf1_lfyact_fullyear_display) AS cal_contvar_cfyf1_lfyact_fullyear_display,        SUM(t1.cal_contvar_cfyf1_cfybud_fullyear_display) AS cal_contvar_cfyf1_cfybud_fullyear_display,        SUM(t1.cal_contvar_cfyf2_lfyact_fullyear_display) AS cal_contvar_cfyf2_lfyact_fullyear_display,        SUM(t1.cal_contvar_cfyf2_cfybud_fullyear_display) AS cal_contvar_cfyf2_cfybud_fullyear_display,        SUM(t1.cal_contvar_cfyf2_cfyf1_fullyear_display) AS cal_contvar_cfyf2_cfyf1_fullyear_display,        SUM(t1.cal_contvar_nfybud_cfyf2_fullyear_display) AS cal_contvar_nfybud_cfyf2_fullyear_display,        SUM(t1.cal_contvar_cfybud_lfybud_fullyear_display) AS cal_contvar_cfybud_lfybud_fullyear_display,        SUM(t1.cal_contvar_cyact_lyact_mtd_display) AS cal_contvar_cyact_lyact_mtd_display,        SUM(t1.cal_contvar_cyact_cybud_mtd_display) AS cal_contvar_cyact_cybud_mtd_display,        SUM(t1.cal_contvar_cyact_lyact_ytd_display) AS cal_contvar_cyact_lyact_ytd_display,        SUM(t1.cal_contvar_cyact_cybud_ytd_display) AS cal_contvar_cyact_cybud_ytd_display    FROM apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis AS t1    WHERE (t1.vmr_code_kfi = 'Vec_11' AND t1.cmentity_type_buz <> 'Holding')        OR (t1.vmr_code_kfi = 'Vec_14' AND t1.cmentity_type_buz = 'Holding')    GROUP BY        t1.cmentity_type_buzunit,        t1.vmr_type_data,        t1.type_displaycurr,        t1.cy_cal_vmr_datep_yyyy_mm_str) b ON b.cmentity_type_buzunit = '${cmentity_type_buzunit}'    AND b.vmr_type_data = '${vmr_type_data}'    AND b.type_displaycurr = '${type_displaycurr}'    AND b.cy_cal_vmr_datep_yyyy_mm_str = '${ymonth}'WHERE r.k = 'Ctrl EBITDA'    AND r.j::text != '0'     AND r.year = LEFT('${ymonth}', 4)    AND (        (r.j::text != '2')         OR         (r.j::text = '2' AND r.b LIKE '%${config_accesscode}%')    )ORDER BY l1

  0个浏览 0个回答 2025年09月24日发布
• 
  公式问题

  SUMIFS('Rawdata-FY'!AL:AL, 'Rawdata-FY'!$E:$E, $J$7, 'Rawdata-FY'!$D:$D, Revenue!$C48) SUMIFS('Rawdata-FY'!AL:AL, 'Rawdata-FY'!$D:$D, $C48, 'Rawdata-FY'!$E:$E, $J$7)这两个公式有什么区别，当前表就是Revenue,写sql时关联条件没法做区别，值却不对SELECTFROM raw_finerpt_config_vprpt_displaysetting r LEFT JOIN apv_d4f_vw_trans_vmr_vm0001_0800800_op_ori_dis a     ON a.vmr_code_entity = r.c  --C48    AND a.vmr_code_kfi = 'Vec_01' --J7

  35个浏览 2个回答 2025年09月19日发布
• 
  MySQL使用like怎么防止空注入

  34个浏览 2个回答 2025年09月18日发布
• 
  条件属性可以做隐藏行，导出后的报表可以在excel中点击展开的方式吗

  点击➕可以展开在FR中隐藏(条件属性)的行

  27个浏览 2个回答 2025年09月11日发布
• 
  条件属性问题

  怎么在ds1.G(B1)单元格内设置条件属性，使字段J1=3时，行高为0

  53个浏览 4个回答 2025年09月10日发布

69

6

69

10