Expression Error02

[Anonymous]

I have two tables like the following picture :

I need to make the amount become with and like the following:

1 – Invoice

2 – Finance Charge

3 – Misc Charge

4 – Return

5 – Credit Memo

6 – Payment

-----------------

I try this expression but it doesn't work!

=if(([R_Document Type]) = 'Credit Memo' & 'Payment',( -1 * ([R_Document Amount])),([R_Document Amount]))

[eduardo_sommer]

The field name were missing after the and (which in fact shoul be an OR)

Also, the & operand concatenate both strings.

=if([R_Document Type] = 'Credit Memo' OR [R_Document Type] = 'Payment',( -1 * ([R_Document Amount])),([R_Document Amount]))

Eduardo

[Anonymous]

it's still plus !!

Regards,

[PrashantSangle · Accepted solution]

Hi,

try like

if(wildmatch([R_Document Type],'*Credit Memo*','*Payment*'),-1*[R_Document Amount],[R_Document Amount])

Regards

[eduardo_sommer]

Where did you put this expression? In the load script or UI Object?

[Anonymous]

thanks it's working

[Kushal_Chawda]

try

=if(match(lower([R_Document Type])=,'credit memo', 'payment'),( -1 * ([R_Document Amount])),([R_Document Amount]))