Sum of Last Day Sales

[Anonymous]

Platform	OI_Systeminfo.virtual	Inventory	Date	count
AI	Virtual	CCMF	11/25/2017	51
AI	Virtual	CCMF	11/26/2017	51
AI	Virtual	CCMF	11/27/2017	52
AI	Virtual	CCMF	11/28/2017	52
AI	Virtual	CCMF	11/29/2017	52
AI	Virtual	CCMF	11/30/2017	52
AI	Virtual	CCMF	12/1/2017	52
AI	Virtual	CCMF	12/2/2017	52
AI	Virtual	CCMF	12/3/2017	52

This series getting increase as per the new date .

I have tried a expression /Set analysis ,

=sum({<Date={Today(),-1}>},count))

which is not working .Please help

I need sum of count for all type of platform .

Let me know if you need any more details

[OmarBenSalem]

just replace the and with ,

sum({<Date={"$(=Max(Date))"},Info={'Virtual'} ,Inventory={'DDM'}>}count)

[kaanerisen]

Hi,

Sum({<Date={"$(=max(Date))"}>} Count) -

Sum({<Date={"$(=date(max(Date)-1,'MM/DD/YYYY'))"}>} Count) is fine but it will not cover all situation. For Example If it is not a working day before a day from last date, then calculation will be wrong.

Sum({<Date={"$(=max(Date))"}>} Count) -

Sum({<Date={"$(=max(Date,2))"}>} Count) will be much better approach I guess.

[Anonymous]

Done ..Thank You very much