8 Replies Latest reply: Dec 9, 2016 9:22 PM by Sunny Talwar RSS

    OLE BD - ACCESS BD - Formula to only count today's entries

    Dean Vincent



      Please could i ask for your help...


      I have created a DB, that is updated daily but i need to pull the figures out just from today??


      The FX i created doesn't work:


      Count({$<[Created]>*(<[Import Date]={0}>)}[Import Date])


      Created is a field/measure


      Import Date is the Dimension


      I will then need to create a FX for 28 days and 90 days.... (+  there will be other fields added later)


      Any Ideas??