Skip to Content
Former Member
Nov 19, 2007 at 01:16 PM

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.