Conditional Calculated Field

Hi!
I am trying to create a calculated field within SRS.
If value of TYPE.field = '9' OR '0', I want the value of another field
'CURTRXAMT' to be multiplied by '-1'
If TYPE.field <>'9' or '0', I want to use the CURTRXAMT as is.
How would I do this as a calculated field in SRS. I thinking of the IIF
expression, but was not sure about the syntax.
Thanks for your help!
Ranjit CharlesIIF ( (Fields!TYPE.Value=9) or (Fields!TYPE.Value= 0) ,(-1) *
Fields!CURTRXAMT.Value , Fields!CURTRXAMT.Value)
--
André Cruz - BI Analyst
Curitiba - Brazil
"Ranjit Charles" wrote:
> Hi!
> I am trying to create a calculated field within SRS.
> If value of TYPE.field = '9' OR '0', I want the value of another field
> 'CURTRXAMT' to be multiplied by '-1'
> If TYPE.field <>'9' or '0', I want to use the CURTRXAMT as is.
> How would I do this as a calculated field in SRS. I thinking of the IIF
> expression, but was not sure about the syntax.
> Thanks for your help!
> Ranjit Charles