请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
帆软用户Dcu3auzqkx(uid:2916235)
职业资格认证:FCA-FineDataLink | FCP-FineBI V6.x | FCP-报表交付工程师
  • L44*VLOOKUP($H44,$H$1:$T$3,$L$4,FALSE)/VLOOKUP($H44,$H$1:$T$3,$J$4,FALSE)-J44这种公式怎么在FR里实现
  • 在新sheet里,对两个sheet数据做除法:结果存在无穷大,怎么处理
  •  
  • 字段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
  • 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
  • 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
  • 点击➕可以展开在FR中隐藏(条件属性)的行
  • 怎么在ds1.G(B1)单元格内设置条件属性,使字段J1=3时,行高为0

69

6

69

10

个人成就
内容被浏览3,711
加入社区1年5天
返回顶部