6 Replies Latest reply on May 19, 2016 9:24 AM by 3193829

    Calculating Variance dymanically


      Hi All,

      I have requirement to calculate Day over Day Variance. And user can select the Date  from the prompt, and i need to calcualte previous day of it to use in my formula.

      Right now i am using the below formula, it is causing performance issues as i have nearly 20 columns with the same calculations.

      DoD sales = Filter(sum(sales) using Date={today}) - Filter(sum(sales) using Date={previous day}).

      Is there any other easier way of doing this so that i dont see performance issues.