为指标 SSRS BIDS 添加多个规则
我制作了一份报告，您可以通过该报告深入查看带有勾号和叉号的表格。每个勾号表示任务已完成。在第二张图片中，您可以看到指示任务分类为已完成还是未完成的规则，如下所示：
如果剩余时间 = 0，则任务已完成，因此会出现勾号。 如果剩余时间在 0.01 到 1,000,000 之间，则仍有工作需要执行，因此任务未完成。
对“总工作量”列的监督，如果这是 0.00 并且剩余时间也是 0.00 那么这意味着任务尚未开始，因此不完整，但是由于我的规则，这些未开始的任务旁边会出现一个勾号。
我的问题是，如何添加第二个规则来考虑“总努力”，因为据我所知，我只能从下拉框中选择一个值，然后为此填充。
规则必须是： 如果剩余时间 = 0 且总工作量 >= 0.01，则显示绿色勾号 如果剩余时间在 0.01 到 1,000,000 之间，则出现红叉 如果总工作量 = 0.00 且剩余时间 = 0.00，那么红十字
希望这是有道理的。
I have produced a report which allows you to drill down into the table you see with ticks and crosses. Each tick indicates that a task is complete. In the second picture you can see the rules which dictate whether the task is classes as complete or incomplete and they are the following:
If Remaining Hours = 0 then the task is complete and therfore a tick appears.
If Remaining Hours is between 0.01 and 1,000,000 then there is still work to be carried out and therfore the task is not complete.
The oversight on this the 'Total Effort' column, if this is 0.00 and remaining Hours is also 0.00 then it means that the task has not began yet and is therfore incomplete however due to my rules, a tick is appearing next to these unstarted tasks.
My question is, how do I add a second ruling to take into account 'Total Effort' because as far as I can see I am only able to select one value from the drop down box and then populate just for that.
The rules need to be:
If Remaining Hours = 0 and Total Effort >= 0.01 then a green tick
If Remaining Hours is between 0.01 and 1,000,000 then a red cross
If Total Effort = 0.00 and Remaining Hours = 0.00, then red cross
Hope this makes sense.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
=iif(Sum(Fields!EffortRemaining.Value) =0 和 Sum(Fields!TotalEffort.Value) >= 0.01,1,0) 为值表达式
然后告诉红叉代表 0 和绿色勾号代表 1
=iif(Sum(Fields!EffortRemaining.Value) =0 and Sum(Fields!TotalEffort.Value) >= 0.01,1,0) for value expression
Then tell red cross for 0 and green tick for 1