Friday, May 30, 2014

Total for the detail

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