0 Replies Latest reply: Mar 15, 2018 4:47 AM by Arvind Verma RSS

    Table not refreshing data

    Arvind Verma

      Hi

      I have 3 tables on a worksheet.

      The first table is for Week - This is dependent on user selection of week.

      The 2nd and 3rd table are showing details of Month to Date and Year to Date (Date of Week selected)

       

      I am using the formula as below for month - for year I use inyeartodate

      sum({1}-1*(InmonthToDate(SCSDAT,CurYearWeekEnd,0)*SCPAX))

      SCSDAT - is the date field

      CurYearWeekEnd is the selected value from the filter - this is a field in the table and is equivalent to weekend(SCSDAT)

      SCPAX is the field I want sum of.

       

      The weekly table gets refreshed on change of the week selection

       

      However the 2 other tables which are for month and year don't refresh with the new selection. However if I open and edit the table and change the formula (rather re-save) then the table gets refreshed and correct values are displayed

       

      Anyway for refreshing the other 2 tables automatically? Is there a refresh command?

       

      Any work around would be appreciated.

      Thanks

      Arvind