如何删除NaN [英] How to remove NaN

问题描述

 

我有几个地方可以计算百分比，我想知道如何修改要删除的代码NaN的。谢谢。

= Count（Fields！SNAP_NOTICE_COMPLETE.Value）/ReportItems！CLIENT_ID1.Value

= Count（Fields！SNAP_NOTICE_COMPLETE.Value）/ReportItems！CLIENT_ID6.Value

= Count（Fields！JV290_PRINT_IND.Value）/ ReportItems！CLIENT_ID6.Value

解决方案

尝试替换为替换（ Count（Fields！SNAP_NOTICE_COMPLETE.Value）/ReportItems！CLIENT_ID1.Value，" NaN"""）

或

= IIf（ReportItems！CLIENT_ID1.Value = 0，Nothing，Count（Fields！SNAP_NOTICE_COMPLETE.Value）/ReportItems_CLIENT_ID1.Value）

Hi, 

I have several places to calculate percentage and i wonder how i can modify the code to remove NaN. Thank you.

= Count(Fields!SNAP_NOTICE_COMPLETE.Value)/ReportItems!CLIENT_ID1.Value

= Count(Fields!SNAP_NOTICE_COMPLETE.Value)/ReportItems!CLIENT_ID6.Value

= Count(Fields!JV290_PRINT_IND.Value) / ReportItems!CLIENT_ID6.Value

解决方案

Try replace as Replace(Count(Fields!SNAP_NOTICE_COMPLETE.Value)/ReportItems!CLIENT_ID1.Value,"NaN"," ")

or

=IIf(ReportItems!CLIENT_ID1.Value=0, Nothing, Count(Fields!SNAP_NOTICE_COMPLETE.Value)/ReportItems!CLIENT_ID1.Value)

这篇关于如何删除NaN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！