这种写在if里面咋写呀

${if(len(AMOUNT_INTERVAL) == 0,"","CASE

WHEN ${PARAMETER_TYPE}TOTAL_AMOUNT < 2000 THEN '两千以下'

WHEN ${PARAMETER_TYPE}TOTAL_AMOUNT BETWEEN 2000 AND 4999 THEN '两千元~五千元以下'

WHEN ${PARAMETER_TYPE}TOTAL_AMOUNT BETWEEN 5000 AND 10000 THEN '五千元元~一万元'

WHEN ${PARAMETER_TYPE}TOTAL_AMOUNT BETWEEN 10001 AND 50000 THEN '一万元以上~五万元'

WHEN ${PARAMETER_TYPE}TOTAL_AMOUNT BETWEEN 50001 AND 100000 THEN '五万元以上~十万元'

WHEN ${PARAMETER_TYPE}TOTAL_AMOUNT >100000 THEN '十万元以上' END

in ('" + AMOUNT_INTERVAL + "')")}

FineReport 予i 发布于 2023-11-9 11:10

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共1回答

最佳回答

Z4u3z1Lv6专家互助
发布于2023-11-9 11:11（编辑于 2023-11-9 11:12）

${if(len(AMOUNT_INTERVAL) == 0,"","CASE

WHEN "+PARAMETER_TYPE+"TOTAL_AMOUNT < 2000 THEN '两千以下'

WHEN "+PARAMETER_TYPE+"TOTAL_AMOUNT BETWEEN 2000 AND 4999 THEN '两千元~五千元以下'

WHEN "+PARAMETER_TYPE+"TOTAL_AMOUNT BETWEEN 5000 AND 10000 THEN '五千元元~一万元'

WHEN "+PARAMETER_TYPE+"TOTAL_AMOUNT BETWEEN 10001 AND 50000 THEN '一万元以上~五万元'

WHEN "+PARAMETER_TYPE+"TOTAL_AMOUNT BETWEEN 50001 AND 100000 THEN '五万元以上~十万元'

WHEN "+PARAMETER_TYPE+"TOTAL_AMOUNT >100000 THEN '十万元以上' END

in ('" + AMOUNT_INTERVAL + "')")}

---------

你有不有XXXTOTAL_AMOUNT字段哦，比如当PARAMETER_TYPE为 test是就是testPARAMETER_TYPE字段

1关注人数

214浏览人数

最后回答于：2023-11-9 11:12

活动推荐更多

热门课程更多

确定取消