• 
  单元格公式不生效，放到不同位置，前公式生效，下面相同逻辑公式不生效什么原因

  公式如下：IF(    LEFT($period,4) < LEFT($date,4),    月报_鹏龙行业务明细数据.select(IF("11"<=RIGHT($period,2), yactual_value_11, predicted_value_11), brand_nm = B6 && key_financial_indicator = C6),    IF(        RIGHT($period,2) = N5,        IF(            (RIGHT(REPLACE(LEFT($date,7),"-",""),2) = N5 && RIGHT(REPLACE(LEFT($date,10),"-",""),2) > $maxkb)             ||             (RIGHT(REPLACE(LEFT($date,7),"-",""),2) - 1 = N5 && RIGHT(REPLACE(LEFT($date,10),"-",""),2) < $minkb),            快报_鹏龙行业务明细数据.select(kactual_value_11, brand_nm = B6 && key_financial_indicator = C6),            月报_鹏龙行业务明细数据.select(yactual_value_11, brand_nm = B6 && key_financial_indicator = C6)        ),        IF(            RIGHT($period,2) > N5,            上月_鹏龙行业务明细数据.select(yactual_value_11, brand_nm = B6 && key_financial_indicator = C6),            月报_鹏龙行业务明细数据.select(predicted_value_11, brand_nm = B6 && key_financial_indicator = C6)        )    ))第二的没出数据的公式如下：IF(    LEFT($period,4) < LEFT($date,4),    月报_鹏龙行业务明细数据.select(IF("11"<=RIGHT($period,2), yactual_value_11, predicted_value_11), brand_nm = B10 && key_financial_indicator = C10),    IF(        RIGHT($period,2) = N9,        IF(            (RIGHT(REPLACE(LEFT($date,7),"-",""),2) = N9 && RIGHT(REPLACE(LEFT($date,10),"-",""),2) > $maxkb)             ||             (RIGHT(REPLACE(LEFT($date,7),"-",""),2) - 1 = N9 && RIGHT(REPLACE(LEFT($date,10),"-",""),2) < $minkb),            快报_鹏龙行业务明细数据.select(kactual_value_11, brand_nm = B10 && key_financial_indicator = C10),            月报_鹏龙行业务明细数据.select(yactual_value_11, brand_nm = B10 && key_financial_indicator = C10)        ),        IF(            RIGHT($period,2) > 11,            上月_鹏龙行业务明细数据.select(yactual_value_11, brand_nm = B10 && key_financial_indicator = C10),            月报_鹏龙行业务明细数据.select(predicted_value_11, brand_nm = B10 && key_financial_indicator = C10)        )    ))

  18个浏览 2个回答 2025年06月21日发布
• 
  如何将打印和导出设置到参数面板中

  我想将工具栏中打印和导出 设置到参数面板中，请问该如何实现？

  17个浏览 3个回答 2025年04月28日发布

2

1

2

10