Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good evening.
I have a formula that calculates and depending on the values 1 or 0 exposes.
If (Count (
{<Date = {"= Count ({$ <[MonthDel] * = {1,4,7,10}, SC_Sales_Pcs_Volume = {1}, type = {'Sale'}>} distinct ItemId)> = SKUQty"} >} Distinct Date)> = ShipmentQty, 1,0)
Thus SKUQty may be from 1 to 5.
But it works only when the field is selected filter SKUQty jobs with a single value.
Tell me how to make it so that the formula would automatically inserts all the values SKUQty
So... if SKUQty may be from 1 to 5... would you like to sum those values or which would be the rule to choose the correct SKUQty value?
Perhaps you need to use Aggr... something like:
Aggr(
If (Count (
{<Date = {"= Count ({$ <[MonthDel] * = {1,4,7,10}, SC_Sales_Pcs_Volume = {1}, type = {'Sale'}>} distinct ItemId)> = SKUQty"} >} Distinct Date)> = ShipmentQty, 1,0)
,SKUQty )
Carlos unfortunately your advice did not help. All my Problem is that SKUQty clearly exhibited in the expression without filters so it (the formula is not considered).
It'll be easier to help you if you upload a sample qvw. I don't get the exact problem / result expected.
Can you spell out what are you trying to do? It isn't clear form your expression. Looks to me that you are comparing count of the distinct date to shipment Qty, that does not look right.