Dual condition

[kalyandg]

Hi all,

             I have a doubt in producing dual conditions for expression, is it possible?

my expression is                  if(TagStatus='OPEN', Pieces) as PcsinHand -------- set in script

                                           sum(if(Year=vCurrentYear and Month=CurrentMonth, PcsinHand)) ---- used for chart expressions

(or)                                       sum(PcsinHand) --- also used in chart

but no results are displaying for the year and month selection, thats why i tried second expr. till it is not giving result

but third expression gives correct values and values are null when i select year and month for this expr.

please help me to solve this issue.

Thanks in Advance,

Kalyan

[fdelacal]

trie with this

Sum({<[Year] = {$(=Year(Today()))},[Month]={"}PcsinHand)

hope it helps you.

Regards