Dual condition

kalyandg — Thu, 27 Dec 2012 05:04:00 GMT

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

Re: Dual condition

fdelacal — Thu, 27 Dec 2012 15:38:23 GMT

trie with this

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

hope it helps you.

Regards