#84 — Accumulation for Continuous Occurrence of A Certain Condition


Problem description & analysis:
There is a statistical table for daily sales:
Task: We want to add a column to the right to calculate the cumulative days of consecutive rising (to calculate in cell C1).
Solution:
Use SPL XLL and the code is as follows:
A
1 =0
2 return E(‘A1:B32’).new(if(Sales>Sales[-1], A1=A1+1,A1=0):RiseDayCount)
A2: Take A1 as a temporary value. A1 plus 1 when the sales volume rises, and assign A1 to 0 when the sales volume falls.
The results are shown below:
Download esProc Desktop for FREE and subscribe for more data analysis tips!!! 🚀🔥⬇️
✨SPL download address: esProc Desktop FREE Download
✨Plugin Installation Method: SPL XLL Installation and Configuration
✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases
✨YouTube FREE courses: SPL Programming
Subscribe to my newsletter
Read articles from esProc directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by

esProc
esProc
esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine. FREE download👉🏻: https://www.esproc.com/download-esproc