Monday, March 12, 2012

Help !!! How do I count Character results!

I have the following problem, I need to create the TotalsY and TotalsN values.

Can anybody give some direction on how to count these character values.

Column1 Y

Column 2 Y

Column 3 N

TotalsY 2

Totals N 1

Column1 =First(Fields!NOB_Pickup_L_D_T.Value)

Column 2 =First(Fields!NOB_Return_L_D_T.Value)

Column 3 =First(Fields!NOB_New_L_D_T.Value)

TotalsY 2 <I Dont Know>

Totals N 1 <I Don't Know>

Thanks,

Rick

Hello Rick,

Try this:

TotalsY

=Count(IIf(Fields!YesOrNo.Value = "Y", 1, Nothing))

TotalsN

=Count(IIf(Fields!YesOrNo.Value = "N", 1, Nothing))

Hope this helps.

Jarret

No comments:

Post a Comment