To have a cumulative value limited by Ready date

[Megacreation]

Hello,

I’am trying with the query below to calculate the cumulative value of issues with Ready date until the last ready date of an issue, the formula is not working,
In my report I have TIME in Rows. Could you help me solve this problem ?

CASE WHEN
DateAfterPeriodEnd([Measures].[Issue Ready Date], [Time].CurrentHierarchyMember)
OR
DateInPeriod([Measures].[Issue Ready Date], [Time].CurrentHierarchyMember)
THEN
CumulativeSum([Measures].[Issues with Ready Date])
END

Thanks and regards,

[gerda.grantina]

Hi @Megacreation ,
I suggest using the standard calculation the cumulative sum without empty values: Create reports

It will create a cumulative sum based on the rows that has a value, see below:

best,
Gerda // support@eazybi.com