Script Wise Subtract

[NavinReddy]

Dear Experts,

I want to apply Subtract in Script Wise

if [Acct 3]='LOB'  i want to subtract [Acct 3]='LOB' - [Acct 6]='CFVTO00049-Tech & Ops Allocations, Internal'

i am writing bellow formula,its not working suggest me is there any way to solve this Issue

IF([Acct 3]='LOB' ,[Acct 3]='LOB'-[Acct 6]='CFVTO00049-Tech & Ops Allocations, Internal',[Acct 3])as [Acct3],

Thanks In Advance

Niranjan

[MarcoWedel]

can you please post some sample data with description of the expected result?

What do you intend with

[Acct 3]='LOB'-[Acct 6]='CFVTO00049

?

If it's two logical expressions you like to subtract, then it would be

([Acct 3]='LOB')-([Acct 6]='CFVTO00049)

because of operator priorities.

regards

Marco