Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to count the item_Id's only if the Sales is not equal to 0. Also the Sales needs to be summed up to the Item_Ids before the condition : Sales not equal to 0 is checked.
I am trying to use this, but I need the Sales to be Sum( Sales).
Count({$<sales={">0 < 0 "}>} distinct Item_Id)
Thanks,
Venu
Thank you sunny,
now i'm cleared.