10.0.3 报表模块颜色工时问题

登录

本帖最后由 CAIT 于 2024-9-23 16:22 编辑

{IIF(Weekday(默认日期, 2) >= 1 And Weekday(默认日期, 2) <= 5 And Not IsNothing(请假时长) And IsNothing(工时合计), "LightGreen",
IIF(Weekday(默认日期, 2) >= 1 And Weekday(默认日期, 2) <= 5 And IsNothing(请假时长) And Not IsNothing(工时合计), "LightGreen",
IIF(Weekday(默认日期, 2) = 6 And Not IsNothing(加班时长) And Not IsNothing(工时合计), "LightGreen",
IIF(Weekday(默认日期, 2) = 6 And IsNothing(加班时长) And IsNothing(工时合计), "LightGreen",
IIF(Weekday(默认日期, 2) = 7 And Not IsNothing(加班时长) And Not IsNothing(工时合计), "LightGreen",
IIF(Weekday(默认日期, 2) = 7 And IsNothing(加班时长) And IsNothing(工时合计), "LightGreen",
"yellow"))))))}

按照条件，加班时长和公式合计都为空的时候，应该也显示绿色才对，这两条加粗的公式没有生效，还是会显示黄色，是有什么问题吗？

Levi.Zhang · Levi.Zhang

大佬，IIF条件嵌套用的有点多，报表表达式是支持Switch判断的哦，可以考虑用【Switch】来做：

语法：Switch(<条件表达式1>, <表达式1>[, <条件表达式2>, <表达式2>,...[, <条件表达式N>, <表达式N>]])

		自动登录	找回密码
密码			立即注册

[处理中] 10.0.3 报表模块颜色工时问题

1 个回复

本帖子中包含更多资源