Round down in dimension level

[amilafdo]

Hi,

I am having a master data as below.

eg: 

Item	Lot No	Qty	No of items per box	Full Box
A	A1	30	8	3
A	A2	28	8	3
B	B1	20	6	3

Note: Full box taken by round down (Floor)

I want to remove the Lot No level in my report & it should be as below.

Item	Qty	No fo items per box	Full Box
A	58	8	6
B	20	6	3

Currently full box for A is coming 7 but it should be 6.

Please guide me how to prepare this report in Qlikview.

Thanks

Amila

[sunny_talwar]

What expression are you using for Full Box? Can you may be share a sample to look at this?

[amilafdo]

Hi Sunny,

I am using the below expression for both.

Floor(Sum(Qty)/[ No of items per box])

Thanks

Amila

[sunny_talwar · Accepted solution]

May be try this

Sum(Aggr(
  Floor(Sum(Qty)/[ No of items per box])
, Item, [Lot No]))

[amilafdo]

Hi Sunny,

Thanks it is working.

Regards

Amila