Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
))
Syntax checker is not perfect. Test your expression and see if it returns the correct result.
Syntax checker is not perfect. Test your expression and see if it returns the correct result.
((
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)
))
Still it is same..!