1 Reply Latest reply on Sep 21, 2019 5:49 PM by Hari Ankem

    Calculated field doesn't change when the linked variables are filtered

    Tim Smit

      The screenshot of my workbook below shows a column "projected revenue" which is a calculated field based on the current revenue and the current number of days. When I adjust the filter to for example 10 till 20 september the revenue and number of days change, but the calculated field doesn't (it always stays the same). Can anyone tell me how I can fix this?

       

      ps the client names are blurred because its private data

       

       

      InkedScreenshot 2019-09-20 at 16.26.16_LI.jpg