Skip to Content
0
Former Member
Jun 09, 2011 at 01:44 PM

Condition on Overal Result (which is a calculated 12 month avrg)

30 Views

Hi Bex Gurus,

I got a report where I need to display all materials which got a low 12 month average shipment figure e.g. 12 month shipment average is about 100 units

However not the materials should be displayed but also the shipments of the last 12 months per month.

To see if dispite a low average the material is "active" -> season product.

Is there a way to accomplish this?

If I define calculating the result of shipments (accorss calendar months) to be calculated as average I see the correct average in the result column. However, I canno't place a condition on just the result column -> still shoing up the single shipment columns.

Any ideas?

Best regards,

Axel