Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bex query calander year/month with calculated keyfigures.

Hi Bw gurus,

i created a query which takes only one calendar month to display Items and sales and average on hand values.

(Average on hand is a calculated key figure which is an average of past 12 months on hand value (on hand in month+ on hand in month-1+.........on hand in month-12)/12).

Now i created same query based on above query but I used calendar year/month interval variable instead of single variable entry. i am getting all the fields with exact values but average on hand (calculated key figure value) is showing wrong data.

Your valid solution deserves the points.

Thank you.

Former Member
Not what you were looking for? View more on this topic or Ask a question