5 Replies Latest reply: Jul 18, 2012 11:32 AM by mayilvahanan ramasamy RSS

    Annualized Expression

    Rebecca Molstad

      I have an expression that gives a 2012 YTD sum, but I want to create another expression to annualize that sum based on the current day that the user looks at the data (to avoid me having to go in and change the expression all the time). Is there an easy way to do this within the expression?

       

      The 2012 YTD expression is as follows:

       

      sum({$<Year={2012},ContractStartDate={'>=1/1/2010
      12:00:00 AM<=12/31/2012 12:00:00 AM'}>}
      FeeOne)+sum({$<Year={2012},ContractStartDate={'>=1/1/2010
      12:00:00 AM<=12/31/2012 12:00:00 AM'}>}
      FeeTwo