SQL expression /// sum SSRS

In the following expression:

=Sum(iif(cint(Fields!Range.Value) >= 0 And cint(Fields!Range.Value) <= 124999
 And (Fields!Date2 = Max(iif(Fields!Range.Value >= 0 And Fields!Range.Value <= 124999 and Fields!Date1.Value
  =Max(Fields!Date1.Value,  "Master_Policy_Number")
  ,Fields!Date2, Nothing), "Master_Policy_Number")),
      cint(Fields!Range.Value), 0))

I need to sum 1 and ONLY one where the coditions are met..


How???
vbnetcoderAsked:
Who is Participating?
 
planoczConnect With a Mentor Commented:
One thing you might want to look at is to  group your Query by Dates; then setup your sum expression per group
0
 
SThayaTechnical MAnagerCommented:
Can you please explain in details your iisue.. currently your syntax is wrong
0
 
vbnetcoderAuthor Commented:
ty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.