Calculate CUmmulative Using Formula Field

[#1]

hi all community,

i want to calculate Cumulative of a field by using formula In Query Designer. Plz help me to calculate cumulative not by setting its property but using formula field in query designer.

Thanks in advance

Edited by: Abdul_Hafeez_25 on May 9, 2010 10:09 AM

[abdul_hafeez4]

Thanks for your attention !

I've got the solution for this prob.

we can calculate the accumulated value of any key figure by adding selections in rows(dimensions) section.

in each date we can give a date range for up to date day to be accumulated.

Although we have to enter daily manually dates but we can. This is one of the way till i found. May be You find better!

All the best and thanks!

[Former Member]

Hi,

norammly field means as per your requirement it is key figure only for that the better option is cumulative property can b used

but u said u want use in forumla

but the values are based on which characterstic those are coming

u can restrict those values with characterstics in RKF and all the RKF can be used in formula. but i am not getting actuall what is the requirement, can you expalin some detailed level.

if i know i can give some input.

Thanks & Regards,

sathish

[abdul_hafeez4]

Hi,

I want to know the cumulative value of "Wastage Quantity" in production year wise. "Wastage Quantity" is a key figure

so i keep "wastage quantity" in column and year in rows side. Now plz tell that how i calculate cumulative of "wastage quantity" without using the property of cumulative.

Regards,

Hafiz Muhammad Hafeez.

Edited by: Abdul_Hafeez_25 on May 10, 2010 10:10 AM