12 Replies Latest reply: Dec 7, 2017 6:39 AM by Sushanta Acharya RSS

    Sum of Last Day Sales

    Sushanta Acharya

         

       

         

      PlatformOI_Systeminfo.virtualInventoryDatecount
      AIVirtualCCMF11/25/201751
      AIVirtualCCMF11/26/201751
      AIVirtualCCMF11/27/201752
      AIVirtualCCMF11/28/201752
      AIVirtualCCMF11/29/201752
      AIVirtualCCMF11/30/201752
      AIVirtualCCMF12/1/201752
      AIVirtualCCMF12/2/201752
      AIVirtualCCMF12/3/201752

      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