Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community!
I have a question.
Case:
CheckId Sku Qty
1 1 2
1 2 5
1 3 7
How can i define Checkid 's that have Qty of every Sku's less than 10??? for example .
I have some problems with P()...
Create a flag like
if(qty>10,1,0) as flag
Use this flag in your expressions accordingly.
Regards,
Arpit
Where exactly are you hoping to use this? In a straight table? and if I read this right, you want to pick CheckId where every Sku has a quantity of less than 10. If there is even one Sku where the quantity is greater than 10, you would not pick it, right? May be this for a straight table
Sum({<CheckId = {"=Count(DISTINCT Sku) = Count(DISTINCT {<Qty = {[<10]}>} Sku)"}>} Qty)
Another way could be this
Sum({<CheckId = e({<Sku = p({<Qunatity = {">10"}>})>})>} Qty)
Thanks!
This example is first what i already tried.
But it doesn't work.
I think i need P() here? Yes?
Can you share a sample where this isn't working.