November 13, 2012 at 2:33 pm
Hi...
I want the count of loannumber when month=7 .
My expression as below.Its returning no value.
=IIF(
(DATEPART("m", Fields!MONTH_2.Value) = DATEPART("m", DATEADD("m", -4, Parameters!V_COPYDATE.Value))) ,CountDistinct(Fields!Loan_Number.Value),NOTHING)
Can anyone correct me please.
Thanks.
November 13, 2012 at 5:11 pm
komal145 (11/13/2012)
Hi...I want the count of loannumber when month=7 .
My expression as below.Its returning no value.
=IIF(
(DATEPART("m", Fields!MONTH_2.Value) = DATEPART("m", DATEADD("m", -4, Parameters!V_COPYDATE.Value))) ,CountDistinct(Fields!Loan_Number.Value),NOTHING)
Break it down into parts. Add temporary columns for each of the pieces of the expression. Visually seeing the parts may shed some light on why it's not working. Remove the columns after you've figured it out.
HTH,
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply