KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a subtotal field for a calculated column that I want to hide when my report has not run yet, because on days with no data, it shows up as NaN on the report. I have tried two methods, but neither are working. I just don't know what is wrong with the expression. I tried hiding if my dataset had no rows: =IIf((CountRows("ScannerStatisticsData")=0),False,True) I also tried making a calculation: =iif((fields!Scans.Value / fields!numberOfCases.Value) = 0, False, True) I also tried checking isnothing on one of the columns in the calculation =iif(IsNothing(fields!Scans.Value), False, True) What am I doing wrong?
Tags (comma-separated)
Save Edits
Cancel