HI guys, I am trying to get the total for a detail. I want sum of NonScan codes only
The code below gives me #error
Sum(IIF (Fields!Class5Code.Value="NonScan", Fields!CURRENT_WEEK_DAILY_DRAW.Value,0 ))
The code below gives the grand total of all codes irrespective of NonScan code
IIF (Fields!Class5Code.Value="NonScan",sum(Fields!CURRENT_WEEK_DAILY_DRAW.Value),0 )
PLease help me with code. Thanks in advance.
svk
No comments:
Post a Comment