Count with 2 conditions

[bbastro1106]

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?

[Kashyap_R]

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,

[Anil_Babu_Samineni]

Perhaps this way?

Count(Distinct {<[SKU Number]={"=Sum({$<[PO Total Units] -= {'0'} and ([PO Total Units]-[Original Units])<0">} [SKU Number])

[sunny_talwar]

May be this

Count(DISTINCT {<[PO Number] = {"=[PO Total Units] <> 0 and [PO Total Units] - [Original Units]) < 0"}>} [SKU Number])