7 Replies Latest reply on Mar 29, 2018 6:22 AM by Martin Dunleavy

# Month running sum until 'yesterday'

I´m using a Running Sum, considering the sales target, the sales and the rate. But, I need to present the running sales and the running rate just until yesterday, but the target still needs to be shown.

How can I use a filter that just works for 2 variables? Is it possible?

Regards,

Júlia

• ###### 1. Re: Month running sum until 'yesterday'

DATEDIFF('day',[Date Field],Today())>0

Use that formula to create a T/F calculated field then drop in your filter card and set to True.

1 of 1 people found this helpful
• ###### 2. Re: Month running sum until 'yesterday'

Hi, Martin,

Thanks for your answer. The point is that I need to show this version, but just the light blue (target) needs to be shown just until the end of the period. The others need to stop to be shown from today on. I´m using Running Sum.

If I use your suggestion, even the target is not going to be shown.

Regards,

Júlia Dreher

• ###### 3. Re: Month running sum until 'yesterday'

Any chance you could post a workbook with some sample data we could work with?

• ###### 4. Re: Month running sum until 'yesterday'

I´ve built a sample.

Please consider the sheet Acumulado. In that, just the blue bar should be shown until the end of the month.

Regards,

Júlia

• ###### 5. Re: Month running sum until 'yesterday'

Martin,

Did you take a look on the workbook I´ve sent?

Thanks a lot.

Regards,

Júlia

• ###### 6. Re: Month running sum until 'yesterday'

I have solved this point.

I´ve used this formula:

IF MAX([Data])<TODAY() THEN

RUNNING_SUM(sum([Sales]))

ELSE NULL

END

I´ve used the same rule for the percentage.

Thanks a lot.

Júlia

• ###### 7. Re: Month running sum until 'yesterday'

I was out of the office the past few days. Glad you solved it!