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

    Sales Today expression

    Fredrik Magnusson



      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