IIF statement in SSRS report - visual studio 2010

Finance and Operations/AX Developer Forum
1

Here are the Table fields:

Status

ChekNo

CustName

TransDate

DueDate

Amount

Cur

NewAmount

I want to insert in the field NewAmount the following if then statement:

If Status=“Cancel”,Amount*-1,Amount

I have tried several times but I failed to write the right if statement

anybody can help?

2

Did you try to compare status with an integer? Status=1

Look at enum value for Cancel.