1 Reply Latest reply: Dec 27, 2012 10:38 AM by facundo de la cal RSS

    Dual condition

    Kalyana Sundaram

      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