Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i solve this problem yesterday, but with no result
I have a formula, where the first part 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 send me an advice where i should pleace a limited conditon for this "containing" expression.Thx a lot. Jaromir
sum({<Year={$(=max(Year))},Week={"$(=max({<Year={$(=max(Year))}>}Week))"},Buyer={'Man'},ItemSuplierCountry={'China'},Centre={'Prag,Viena,Boston'}>}(NAKPRO.qty))
try writing :
Centre={'Prag,Viena,Boston'} - wrong
as
Centre={'Prag','Viena','Boston'} - should be like
try writing :
Centre={'Prag,Viena,Boston'} - wrong
as
Centre={'Prag','Viena','Boston'} - should be like
Hi,
Try this.
sum({<Year={$(=max(Year))},Week={"$(=max({<Year={$(=max(Year))}>}Week))"},Buyer={'Man'},ItemSuplierCountry={'China'},Centre={"Prag","Viena,Boston"}>}(NAKPRO.qty))
Regards,
Kaushik Solanki