change in the script

[Anonymous]

i have these code of line used previously in my application:

IF( = PREVIOUS() AND = PREVIOUS([y]),
(-PREVIOUS())/([Datefield]-PREVIOUS([Datefield])),0) AS W,

above formula is calculating the value of w ,but in start of the quarter its giving 0

now i want to replace the (0) it in such a way that it should calculate based on average of next few values based on y

[ahaahaaha]

If the following values are required for the calculation, you must first load them, and then reload the internal table once again to calculate the required values.

[Anonymous]

i didnt get you

[Siva_Sankar]

Check Get previous row value when the value is null and Check if Previous Previous field is null

Siva

[Anonymous]

syntax plz