Jim Dean
Sage
   
Posts: 3433
Joined: 3/13/2006
Location: L'ville, GA
 User Profile |
Sum(-(V>100000 and C>O), 126) >= 1
The and-condition being true results in (-1), otherwise it’s zero. Negative sign converts it to positive one. Sum function processes that rule for 126 days and adds the results. If it was true for one or more of those days, the sum will report the number of days it was true for.
[Edited by Jim Dean on 1/2/2021 8:43 PM]
|
