Skip to Content
1
Former Member
Jul 02, 2007 at 09:49 AM

query key figures calculation issue

10 Views

Dear Sap Gurus,

I would like to calculate the sum of one key figure on the month m-3 m-2 and m-1

I have created 3 restricted key figures filtered by month m-3, m-2 and m-1

i have created a key figures one which one I sum these 3 key figures but the result per month is not egal to the summation but to the value per month

on the example below

one this field is what i have D- Sum Other Requirements

one this field is what i would like to have Sum Other Requirement Past

Thanks for your answer

Calendar Year/Month janv-07 FEB 2007 mars-07

D- Other Requirements month-6 69,888 PC

D- Other Requirements month-5 281,385 PC

D- Other Requirements month-4 19,854 PC

D- Sum Other Requirements 69,888 PC 281,385 PC 19,854 PC

Sum Other Requirement Past 69,888 PC 351,273 PC 371,127 PC