Issue on Where...In...formula on r3

[hank_pak]

Hi gurus,

I have an issue on migrating a report from r2 to r3.

I have a table as follows,

when I create a table use the formula

=[StandardSalesQty] Where ([PriceFramePublic] In ([SKU])<=1300), it returns blank

Actually, I want to return the [StandardSalesQty] considering the [PriceFramePublic] and [SKU].  

The formula works fine on r2, while returns blank on r3, what is wrong with the above formula?

Best Regards

[former_member189638 · Accepted solution]

Try this

=Sum([StandardSalesQty] ForEach([SKU]) Where ([PriceFramePublic]>1300))

[hank_pak · Accepted solution]

It works, thank you so much.