4 Replies Latest reply: Jun 14, 2018 1:29 PM by Gabriele Cianci RSS

    HOW CAN I DO AN EXPRESSION WHERE I COMPARE DATE??

    Gabriele Cianci

      Hi at all,

       

      I have a simple table like in the image.

       

      table.png

      How can I create a field with a measure measure where I compare sales of present date with past date?

      Sum(sales) / Sum({<Date = {"=Date - 1"}>}Sales) is not correct, in fact the result is 1.

       

      Thank you at all