Skip to Content
Apr 30, 2015 at 03:17 PM

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


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