'where' statement in a variable

[#1]

Hello Community,

I try to make a variable but one of the "where" doesn't work.

Case:

tabel [year]  contains 2015 and 2016

tabel [type]  contains 'D' (deliver) and 'R' (receive)

tabel [amount] contains lines with # items.

In a variable i want to calculate the amount of [type] in a [year]

this is what i use:

Sum({<[type]={'D','d'}>}{<[year]={'2016'}>}[amount])

as result i see the total amount in 2016 but not the amount of deliver in 2016 (the result is the amount of deliver + receive in 2016).

how can i fix this?

[swuehl · Accepted solution]

Sum({<[type]={'D','d'}, [year]={'2016'}>}  [amount])

[varshavig12]

Sum({<[type]={'D','d'} , [year]={'2016'}>}[amount])

[#4]

Thanks for the quick respons. Comma makes the difference .