Question about expression

[sergioskv]

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()...

[arpitkharkia]

Create a flag like

if(qty>10,1,0) as flag

Use this flag in your expressions accordingly.

Regards,

Arpit

[sunny_talwar]

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)

[sergioskv]

Thank u.
This flag will show result for each row. But i don't need like sum({<Flag={0}>} sales).
I need full check sales, if no rows with qty > 10 in this check?, else i don't want to see this check completely.

[sunny_talwar]

Another way could be this

Sum({<CheckId = e({<Sku = p({<Qunatity = {">10"}>})>})>} Qty)

[sergioskv]

Thanks!

This example is first what i already tried.

But it doesn't work.

[sergioskv]

I think i need P() here? Yes?

[sunny_talwar]

Can you share a sample where this isn't working.