sumc(value[, condition])


Description

for sum all children values if condition is true
If no condition given ten th condition is assumed to be true.

Example

++:C!-:sumc(fv("times") * fv("Price"), fv("Price") > 1):countc(fv("Price")) > 0
the flag for this example indicates that it will only act when a child level item changes (C!-)
tha value is the sum of the product of the "times" folder and the "Price" folder (sumc(fv("times") * fv("Price"), fv("Price")).
The contained condition is that the value of the "Prive" folder must be greater than 1 ( fv("Price") > 1)
the ending condition is that the count of teh child folders is greater than 0 (countc(fv("Price")) > 0)

Related Rules

sumd()