Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
trie with this
Sum({<[Year] = {$(=Year(Today()))},[Month]={"}PcsinHand)
hope it helps you.
Regards