Discussions

Expand all | Collapse all

Calculated fields keep diappearing

  • 1.  Calculated fields keep diappearing

    Posted 07-11-2017 12:04
    Hello,

    I created two formula fields in a table that are used to extract the year and week number from the date codes in my original data set. However, these fields periodically show up blank in the table and reports, even though they were correct when I viewed them earlier.  The only way I've found to get it to go back to normal is to open the properties for one of the fields and save it again, which causes both to show up correctly again.

    While this is only a minor nuisance for me, I'd like to find a way to prevent this from happening to other users when the app is complete.  Any input would be greatly appreciated!


  • 2.  RE: Calculated fields keep diappearing

    Posted 07-11-2017 12:55
    I figured it out by creating a separate table just for the date conversions and used those as lookup fields in the main table, which seemed to help since it didn't have to do a separate calculation for every line of data.


  • 3.  RE: Calculated fields keep diappearing

    Posted 07-12-2017 13:28
    I think this will help you to show the year and week directly in a single field

    var number days = ToDays( [Date] -Today());
    Year([Date])&"_"&Ceil(ToWeeks(Days($days)))

    Replace Date with your date field 

    I hope this will solve your issue!!