6 Replies Latest reply: Apr 10, 2017 3:17 AM by Stefan Piskorski RSS

    Adding Datenum to calendar invalidates all formulas?

    Stefan Piskorski



      I had a calendar in my QV document that was structured :


      month_no_id     week_no_id     year     monthname     day     calendar_date                 week     month     quarter

      201012               201052          2010     Dec               30       30/12/2010 00:00:00      52               12     1


      and the formula

          =sum({$<[calendar_date]={"$(=Only([calendar_date]))"}>} [gross] )

      worked to give the sales on the selected day


      I added    Floor(calandar_date) tp my load script which added:





      to the calendar, and now the above formula won't work.


      I don't understand why - does anyone know why this is?


      Much appreciated