runningSum also return NULL on NULL value

Q&A
, ,
1

Hello everyone, i’m doing a visual that look kinda like this:

image
image361×527 23 KB

Simply listing every date of current month, value of each day and cumulative value. I’m calculation cumulative value using below calculated field:

runningSum(sum({value}),[truncDate("DD",{date}) ASC])

However, as you can see, even tho the value is NULL (because they’re future date, they won’t have value), cumulative value still return the same last value. I want cumulative value also return NULL if value is NULL. Is it possible to achieve this?

2

You can create another dimension that differentiates past months from future months and add it to the partition as shown below

runningSum(sum(Sales), [truncDate("DD",{Order Date}) ASC], [isFuture])

I got the below results where i qualified everything in 2023 as Future and the Future days had null for Sales

cumulative-sum

1 Like
3

Thank you, it worked! Thanks for fast solution!