Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am now working on a expression to perform a distinct count for SKU number, if 2 criteria match:
1) If PO total units <> 0
2) If PO total Unit - Original Unit < 0
I try below expression, but it cannot give me the correct result.
Count(Distinct {<[SKU Number]={"=Sum({$<[PO Total Units] = - {0}>} [PO Total Units]-[Original Units])<0"}>} [SKU Number])
Can anyone please help?
Hi
Hope this solution works for you,
if(Sum([PO Total Units]) >=600 and (Sum([PO Total Units])-Sum([Original Units])) > 30,Count(distinct [SKU Number]),0)
Thanks,
Perhaps this way?
Count(Distinct {<[SKU Number]={"=Sum({$<[PO Total Units] -= {'0'} and ([PO Total Units]-[Original Units])<0">} [SKU Number])
May be this
Count(DISTINCT {<[PO Number] = {"=[PO Total Units] <> 0 and [PO Total Units] - [Original Units]) < 0"}>} [SKU Number])