18 Replies Latest reply: Aug 17, 2017 9:23 AM by Sunny Talwar RSS

    Sales Today expression

    Fredrik Magnusson

      Hello,

       

      I've been trying to set an expression that locks my sales for today. But after going through these forums and youtube and guides I can't seem to get it to work.

       

       

      What I need is todays sales numbers in the Business area "Stores" which is called Affärsområde.

       

      This is what I got right now,

      sum({<Date={'$(=Date(Today(),'DD/MM/YYYY'))'}, Affärsområde={'80 BUTIK'} >} TB)

       

      TB = Sales

      Affärsområde = All the stores we got

       

       

       

      HEEEELP!