Problem to create calculated field using 'if and'

[yossi_bire]

Hi, I'm trying to create a calculated field in the backend mode (not a dimension) with success

if (

LINE_OF_BUSINESS ='Materials'

abd

LEDGER_CURRENCY_CODE='USA'

,'Yes','No')

any suggestion?

[sunny_talwar]

May be you mis-spelled and

if (

LINE_OF_BUSINESS ='Materials'

abd

LEDGER_CURRENCY_CODE='USA'

,'Yes','No')

[mdmukramali]

Hi,

if (

LINE_OF_BUSINESS ='Materials'

AND

LEDGER_CURRENCY_CODE='USA'

,'Yes','No') as FieldName

Thanks,

Mukram.