Hello,
I wanna know if there is a way to calculate the difference of 2 periods as follow:
The difference would be current day sale minus the last working day of previous month.
| Date | Sum | Difference | Note |
|---|---|---|---|
| 8/29/2024 | 2 | ||
| 8/30/2024 | 3 | Last working day | |
| 8/31/2024 | No data | ||
| 9/1/2024 | No data | ||
| 9/2/2024 | 4 | 1 | |
| 9/3/2024 | 5 | 2 | |
| 9/4/2024 | 6 | 3 |
Hi @qtngo,
Please take a look at the attached Arena view. Although the sample data is different, the calculated fields should operate the same way once you plug in your fields. I included text that explains the operations as well. Let me know if you have any additional questions!
Current day vs Last Day of previous month difference