Filtering in expression

[#1]

Hello!

I'm trying to filter my data in the expression as example below:

Sum({$< Year = {"2010"}>}ABC)

This works fine. However, when I try to add another filter I just can't seem to get it right... I've tried many variations of bellow:

Sum({$< Year = {"2010"}>} and {$< Customer = {"AAA"}>} ABC)

(I want to show only ABC values where the Year is 2010 and Customer is AAA)

Is there any way of doing this? I belive I'm just not using the correct syntax.

Thanks in advance!

[Anonymous]

Try Jannemannen,

Try something like this:

Sum(  {$<Year={"2010"},   Customer = {"AAA"}   >}  ABC)

[#3]

Hi,

Try this, this should work.

Sum(  {$<Year={2010},  Customer = {'AAA'}  >}  ABC)

BTW.. New look & feel of the community is owesome..!! I like this.. (nope)..Double like

- Sridhar

[#4]

Thanks for the quick respone.

With your input I managed to solve my problem using the folloing:

Sum( {$< Year = {"2010"}, Customer = {"AAA"} >} ABC)

Thanks again