DDNORM Returns a time-weight normalized result of a daily detail variable. The result is assumed to occur once a day; hence it has to be stored in a daily variable.

The functions behavior is similar to ADIF . However, DDNORM will normalize a daily detail result based on date and time of a daily detail variable. It will distribute the result over any number of days.

SYNTAX:

DDNORM(Cx, OPTIONAL DaysToSearch)
where :
Cx is a conditional variable x
DaysToSearch:  Optional. Number of days to search (into the past) can be optionally specified. DDNORM will search 366 days into the past by default.

 

EXAMPLES:

DDNORM(C45,125)  Searches the values for variable 45 back 125 days.