7 Replies Latest reply: May 9, 2014 6:51 AM by Miikka Koskinen RSS

    Calculate Daily Budget From Monthly Totals

      I have the following table loaded in my script:

       

       

      LOAD
      SourceID,
      BudgetID,
      FiscalYearID,
      AccountID,
      PeriodEndDateTime,
      AccountClass,
      AccountClassType,
      AccountControlAccount,
      AccountControlCode,
      AccountCorporation,
      AccountCorporationName,
      AccountDescription,
      Budget,
      BudgetYTD,
      RowUpdateDateTime
      FROM
      datasources\GlBudgetsByPeriod2011.qvd
      (
      qvd);

       

       

      I have actual amounts (not shown here) by day, and need to display daily budget amounts as well.  The problem is that my budget amounts are monthly totals.  How would you go about this?  In the script?  In the expression?