6 Replies Latest reply on Sep 17, 2018 9:30 AM by Shruthi B S

    Hide last value of Calculated field from view

    Shruthi B S

      Hi Everyone,

       

      Could someone please let me know a solution to hide last value of calculated field Growth .

      Here I'm calculating Week/Week (W/W)Growth btw 2017 & 2018 Bookings. 2017 has all Weeks bookings. 2018 has bookings till latest week. Say 2018 has only till WK20.

      To calculate W/W = (SUM([2018 Bookings])-SUM([2017 Bookings]))/SUM([2017 Bookings])

      But i do not want to display Growth for WK20 because it is still not completed in 2018. Growth chart should stop at WK19, but bookings should be there. Is there a way to achieve this.