Link to home
Start Free TrialLog in
Avatar of jeebukarthikeyan
jeebukarthikeyanFlag for India

asked on

Expression in report viewer

hi,
i have created 2 expresions
 ="$" + Iif(Fields!AMTVARRSN.Value.ToString().IndexOf("NA")>=0,"0.00",Fields!TRANAMT.Value)

if AMTVARRSN.Value.ToString().IndexOf("NA")>=0,
then print  "0.00", othere wise print Fields!TRANAMT.Value...this is working fine

next i need to take the sume of above value
=Sum(Fields!TRANAMT.Value) --this line fail because its always doing the sum of TRANAMT.Value

indeed i need to take the sum from the result of this expression
 ="$" + Iif(Fields!AMTVARRSN.Value.ToString().IndexOf("NA")>=0,"0.00",Fields!TRANAMT.Value)

thax
b u d d h a
ASKER CERTIFIED SOLUTION
Avatar of Niraj_Singh
Niraj_Singh
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial