How to get yesterday data

[Former Member]

Hi,

We have a report where we get data for complete current month with day -1.As listed below how to get yesterday’s data in Total under “Active Base_Count” column.

Please suggest.

Date	Subscription_Count	Active Base_Count
4/24/2016	30	10
4/25/2016	20	15
4/26/2016	10	18
Total	60	18

Thanks

[Former Member]

Hi Shekar,

You can use the below formula :-

=Sum(If ( [Date] = (Max([Date]) ForAll([Date])) ) Then [Active_Count] Else 0)

[Former Member]

You can also use Last([Active_Base_Count]) to achieve the same.

[Former Member]

Thanks

Kashif, it worked

[Former Member]

Cool. You can mark the question as answered to close loop.