Hey there,
I’m currently working on a table calculation, and I’ve noticed that the running sum isn’t functioning correctly due to missing values in the dates. In the provided image, you can see that for Q1, the sales data is missing for day 4 and day 5. In this scenario, I’m wondering if it’s possible to carry forward the value of 1.16M from day 3 to day 4 and day 5 when using the running sum calculation.
The calculation for the running sum is as follows:
nullIf(runningSum(sum({Amount (converted)}), [{test - difference} ASC]),0)
In this calculation, the {test - difference}
field represents the day of the quarter. For example, if the date is January 1st, {test - difference}
would return 1, and for January 2nd, it would return 2, and so on.
If you have any suggestions or insights on how to address the missing values in the running sum calculation, please let me know.