how to write more values in script?

[#1]

hi guys ,

i write an expression like this sum({$<year={2002},category={mobile}>}this expression have only two values but i need to write more values in this expression but i do not know how to write more values in expression.please tell me out how to write more values in expression.

Regards:

madhu

[MK_QSL]

Something Like Below

SUM({$<year = {'2002', '2003'}, category = {'mobile','abc'}>}Sales)

[ariel_klien]

Hi,

you can try:

sum({$<year={2002},category={mobile,Value2,Value3}>}....)

If you want a range of years:

sum({$<year={>2002<2012},category={mobile}>}...)

Hope this will help you.

BR

Ariel

[Colin-Albert]

Your expression is incorrect, you have not stated which field you are summing, also the category value must be within quotes as the data is text.

sum({$<year={2002},category={'mobile'}>} field_to_sum)

[antoniotiman]

You want to say

sum({$<year={2002,2003,2004},category={'mobile','pc'}>} sales)

Regrds

[#6]

thank you ariel

[#7]

thank you colin

[alexandros17]

You are missing something in writeing the expression:

sum({$<year={2002},category={mobile}>} of what?

the correct sysntax is sum({$<year={2002},category={mobile}>} myField)

If you need to add other conditions:

sum({$<year={2002},category={'mobile', 'TV'}, Type={'Flat'}>} myField)

[#9]

Use can create the set expression Variable and use the variable in the expression.This is the best way to manage the repeatedly changing values in the Set idetifieres.

[#10]

You may also like expression like this:

sum({$<year={">=2002"},category={'mobile'}>} myField)

it will calculate for years range.

regards

Darek