need help

[#1]

hi, how can i write this in chart expression?

SELECT (amQty) FROM FCTRAN WHERE substri(FCTRANSIT,1,1)='S' and substri(FCTRANSIT,1,1)='M'

[#2]

sorry ppl,

'SAM','SML' and 'MBO' should be not equal. it s like this

SELECT (amQty) FROM FCTRAN WHERE substri(site,1,1)='S' and substri(site,1,1)='M' and substri(site,1,1) != 'SAM' and substri(site,1,1) != 'SML' and substri(site,1,1) != 'MBO'

[manideep78]

try this

=Sum({<site={'S*', 'M*'} - {'SAM*','SML*','MBO*'}, Month={11}>}amQty)

Note: Make sure your month field should be in standard date format, other wise change it using relevant date functions.

[#4]

You can Use this one

Sum({<site={'S*', 'M*'} - {'SAM*','SML*','MBO*'}, Month={11}>}amQty)

It helps.

[jagan]

Hi,

Try this expression.

Sum({<site={'S*', 'M*'} - {'SAM*','SML*','MBO*'}, Month={11}>}amQty)

Regards,

Jagan.