4 Replies Latest reply: Jul 6, 2016 8:32 AM by Jhonatan Ocampo RSS

    MTD SalesGoals

    Jhonatan Ocampo

      Hi Everyone, I would like to ask what formula should I used if you have the sales goals for the entire month to show me the sales goals MTD,

      This is the one I am using right now but gave me the total sales goals for the month

      sum(if (InMonth ([InvoiceDate], SetDateYear (Today(), max (total Year ([InvoiceDate]))), 0), [SalesGoals]))

      Thanks for your help!