...
2.2 Calculate the maximum/minimum value
Find the sales amount in the day when the sales peaks or declines to the lowest level according to the following daily sales table.
| Date | Sales |
|---|---|
| 2022-01-01 00:00:00 | 98.0000 |
| 2022-01-02 00:00:00 | 174.0000 |
| 2022-01-03 00:00:00 | 168.0000 |
| 2022-01-04 00:00:00 | 167.4000 |
| 2022-01-05 00:00:00 | 1696.0000 |
| … | … |
SPL script:
| A | |
|---|---|
| 1 | =T(“DailySales.xls”) |
| 2 | =A1.max(Sales) |
| 3 | =A1.min(Sales) |
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL
