Hi @Lokesh Obhilineni-Oracle , If you do not intend to use this column as a measure, yes, you should change it in the dataset — change it from a measure to an attribute.

Example: DAYOFMONTH( TIMESTAMPADD( SQL_TSI_MONTH, -5, TIMESTAMPADD( SQL_TSI_DAY, -DAYOFMONTH(CURRENT_DATE), CURRENT_DATE ) ) ) The inner TIMESTAMPADD() is subtracting the DayOfMonth result from the c…

May I suggest: FILTER( WorkDayAccumulated USING( CRTD = SysDate )) or FILTER( WorkDayAccumulated USING( Date = SysDate )) Since CRTD and Date are joined, either one should work OK. I assume your SysD…

Hi Kirk Li, I think the measure will work well in your filter if you perform the WorkDayAccumulated (i.e., Rsum) calculation within the dataset, but not if you perform the calculation within the DV w…

This doesn't answer your question, but I'm not sure a running sum will work properly in a filter function because — I believe — running sum calculates using filtered rows.