2 Replies Latest reply on Oct 18, 2018 2:03 PM by Claudio Pena

    Hide Colums With No Data but a calculated field depends on non filtered data

    Claudio Pena

      Hello!

       

      I am trying to calculate months of stock based on Future Sales.

       

      For example:  Months of Stock = Actual Stock / window_avg (next three months sales)

       

      What is happening is that the graph is showing empty values where the actual stock is zero as the calculation depends on future sales.

       

      How can i dinamically hide this without altering the months of stock calculation?

       

      Hide.JPG