Problem with the number of data when you select a store and when you bring all the data

[geogou1973]

Hello,

I have the following problem.

I bring the 0 stock in a straight chart with the following expression.

sum({<ITEM_ID = {"=sum(STOC) = 0"}>} STOC)

by store and item. If i export all the data for all stores in an excel for example in the store 21 i have 1104 items that have 0 stock. 

If i select from the stores only the 21 and export the data i have 2122 items that have 0 stock that is the correct.

Have anyone an idea why is this happening ?

Is the problem in the expression ?

 Thank you in advance.

I

[Stoyan_Terziev]

Hello Geogou,

If you want to know how many items have 0 STOC per store, here is how you can do this:

Count({<STOC ={0}>} ITEM_ID)

If you want to know how much is the stock overall for items which have 0 stock in some of your shops, pm me and I can help you build the expression.

If working at all, this expression: =sum(STOC) = 0 would give you (-1) if true or (0) if false.

So your expression most likely works like this:

sum({<ITEM_ID = {"-1"}>} STOC)

or like this 

sum({<ITEM_ID = {"0"}>} STOC)

I hope that helps!

Kind regards,

S.T.

[sunny_talwar]

So, you are summing STOC where STOC = 0? I think Sum of many 0's will still be 0, isn't it?

[geogou1973]

Hello,

neither of the expressions do not work.  

[geogou1973]

I want to show all the items for the store or all the stores that have stock 0 

[sunny_talwar]

Show it in which object? What are your dimensions (if it is in a chart) and what are your expressions (other than the one above)?

[geogou1973]

The dimensions are the store and the item and the expression is the following

sum({<ITEM_ID = {"=sum(STOC) = 0"}>} STOC)

and the problem is that when i choice a store a have the correct number of rows 

when i don't choice and i show all the stores and items i have less items per store.

I don't know how that is happening.

[sunny_talwar]

Can you try this

Sum(Aggr(
  If(Sum(STOC) = 0, STOC)
, ITEM_ID, STORE))

[geogou1973]

Does not work correctly. It brings over of 18.000 rows in the store 21.  

[sunny_talwar]

How about this?

Sum(Aggr(
  If(Sum(STOC) = 0, Sum(STOC))
, ITEM_ID, STORE))