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

    Adding Datenum to calendar invalidates all formulas?

    Stefan Piskorski

      Hi,

       

      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:

       

      DateNum

      40907

       

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

       

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

       

      Much appreciated