3 Replies Latest reply: May 9, 2016 9:22 AM by Grant King RSS

    MTD / YTD Is there a better way?

    Grant King

      Hi All,

       

      In my data table i'm trying to display MTD and YTD using a calculation which I have stored in a variable "vQuotes" (below). 

       

      SUM({<[Plan Type]={'Actual'}>} Quote_Count)

       

      The fact calendar I have created has flags for MTD and YTD.  What I was hoping to do in the front end data table which in theory should be simple but I can't get this to work is the following :

       

      $(vQuotes) * MTD

       

      and another for YTD


      $(vQuotes) * YTD

       

      I can get around this by creating new variable which I would call "vQuotesMTD" and would be as follows:

       

      SUM({<[Plan Type]={'Actual'}, MTD = {1}>} Quote_Count)


      But it would mean multiple variables which are only used once and are basically the same.


      Is it possible to do this it this way?


      $(vQuotes) * MTD