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