6 Replies Latest reply on Feb 11, 2019 2:40 PM by Mihai Constantinescu

    Removing High Variance Items In Aggregated View

    Stephen Bava

      Hi,

       

      I am attempting to remove items with a high % variance based on a parameter. For example, Price A is $1 and Price B is $4. 4/1 = 400%. I can create a calculation that says "% variance > X%", and it works fine in a view that lists out the products.

       

      However, if I remove the products and want an overall view summed up to a category, the calculation doesn't work.

       

      Works at the product level.

      When products aren't in view, the % variance doesn't work, and still show all variances.