公式如下：

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)

        )

    )

)