8 Replies Latest reply on Oct 12, 2018 5:27 PM by Shinichiro Murakami

    Calculation with date parameters/Aggregate & Non-Aggregate

    Beth Roberts

      Good day all,

       

      I am working on a budget projection workbook. This is what I need:

       

      Remaining Balance FY19 = YTD Spend FY18-Current Spend FY19

       

      The YTD Spend is {FIXED [Eff Dte],[Account],[App Code]:sum([Amount])}

       

      I cannot for the life of me figure out how to put conditions on the date so that we can show project managers when they are going to go over budget.

       

      Any help you can provide would be great.

       

      Thank you!
      Beth