OR Statement 2

[obtechuser]

Need assisatnce in using an OR statement.
I have the below formula in my report and am receiving an 'boolean is required' error.

if {tb005_CollateralbyCust.CollateralID} = 48 or 67 or 65 then {tb002_LCRMasterFinal.ActualAmount}

Inquiring as to the proper way to construct this formula.

Thank You,
Marco
Crystal 10

 

[hilfy]

You can't use OR in this manner - you would have to include the field before every number, like this:

if {tb005_CollateralbyCust.CollateralID} = 48 or
{tb005_CollateralbyCust.CollateralID} = 67 or
{tb005_CollateralbyCust.CollateralID} = 65 then {tb002_LCRMasterFinal.ActualAmount}

-Dell


A computer only does what you actually told it to do - not what you thought you told it to do.

 

[obtechuser]

This worked perfectly.

Thank You,
Marco

 

[lbass]

You could simplify this to:

if {tb005_CollateralbyCust.CollateralID} in [48,67,65] then
{tb002_LCRMasterFinal.ActualAmount}

-LB