Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i´m asking for an advice.
I have an expression :
Sum
({<acount={'0,1,2'},>}(NAKPRO.qty)) ....i know it´s wrong, i want to say: Calculate all items only of acount "0","1","2"....so there must be some function of containing these types of acountThx a lot:-)
Jaromir
IF(acount=rowno(),NAKPRO.qty)
or try this
if(acount>=0 or acount <= 10,NAKPRO.qty)
try this
if(match(acount,'0','1','2'),NAKPRO.qty)
Thx guys,
your advices don´t work:-(
In fact, my formula is more complicated:
sum({<Year={$(=max(Year))},Week={"$(=max({<Year={$(=max(Year))}>}Week))"},Buyer={'Diana'},ItemSuplierCountry={'China'},Centre={'Prag,Viena,Boston'}>}(NAKPRO.qty))
The first part of formula defines the last one week of period for statistic, then some conditions and the last one is my request - possibility of limit concreete places of sale.
Please tell me where i should pleace a limited condition
Thx a lot
J.