Set analysis exclude!

[#1]

Can anyone explain me what's wrong in this expression, once I added the exclude script rest of the expression changing from default colors (black red green) to black. But expression window shows me expression is ok.

((

Sum( {$<Year={$(v)},SalesType={'Gross'}>} SalesAmt)

+ Sum({$<Year={$(v)},SalesType={'WOff'}, SaleWOType -= {bad_debt}>} SaleWOAmount)

  + Sum( {$<Year={$(v)},SalesType={'Fee'}>} SalesAmt)

  - Sum( {$<Year={$(v)},SalesType={'Returned'}>} SalesAmt)

))

[luciancotea · Accepted solution]

Syntax checker is not perfect. Test your expression and see if it returns the correct result.

[venkatg6759]

((

Sum( {$<Year={$(v)},SalesType={'Gross'}>} SalesAmt)

+ Sum({$<Year={$(v)},SalesType={'WOff'}, SaleWOType -= {'bad_debt'}>} SaleWOAmount)

  + Sum( {$<Year={$(v)},SalesType={'Fee'}>} SalesAmt)

  - Sum( {$<Year={$(v)},SalesType={'Returned'}>} SalesAmt)

))

[#4]

Still it is same..!