Share of Promotion Products 

Technical name: 0RT_C30_Q0013

Use

This Query provides an overview of the proportion of promotion articles in the POS receipts in relation to the total number of products.

Rows

InfoObject	Description of the InfoObject (also restrictions or calculation formulas)
0PLANT	Location

Columns

InfoObject	Description of the InfoObject (also restrictions or calculation formulas)
0RT_NOSALRE	Number of POS Receipts
0RT_NOARTRE	Number of Products
0RT_NOPARTR	Number of Promotion Products
0RT_C30_CK007	Number of Promotion Products / POS Receipt (see formula)
0RT_C30_CK004	Share of Promotion Products (see formula)
0RT_C30_CK005	Number of Products / POS Receipt (see formula)

Formulas:

·        Number of Promotion Products / POS Receipt

Number of Promotion Products / POS Receipt =

Number of Promotion Products ¸ Number of POS Receipts

·        Share of Promotion Products

Share of Promotion Products =

100 ´ Number of Promotion Products ¸ Number of Products

·        Number of Products / POS Receipt

Number of Products / POS Receipt =

Number of Products ¸ Number of POS Receipts