Home Forums Reporting Services Reporting Services 2005 Development Help with FilterExpression in BIDS 2005 - I'm going crazy RE: Help with FilterExpression in BIDS 2005 - I'm going crazy
davoscollective
SSCertifiable
Points: 6355
More actions
March 5, 2013 at 5:45 pm
#1593700
How about
Expression: =CDec(Fields!Collected.Value/Fields!Discounted.Value)
Value: =0.01
I suspect that dividing two decimals is giving you a float datatype, so convert them to decimal after the division.