1 Reply Latest reply on Feb 2, 2019 5:47 PM by Hari Ankem

    Calculated field help

    Tim Mullady

      Hello,

       

      I wanted to see if someone could help me create a calculated field

       

      I have two fields [CY PAX], [CY NET WEEKLY PAX], and [WEEK ENDIN

       

      I simply want to add them together [CY PAX] + [CY NET WEEKLY PAX] but I wan't to the [CY NET WEEKLY PAX] value to stay filtered to [WEEK ENDING] = #08/04/2018#

       

      So the [CY PAX] with change each week but I want to always back the Values from [CY NET WEEKLY PAX] on 08/04/18.

       

       

      Any help would be greatly appreciated.

       

      thanks,

       

      Tim