2 Replies Latest reply: Mar 29, 2017 2:37 PM by Clever Anjos RSS

    I want to ignore a date field but set expression is wrong?

    Oliver Clarke

      Hi

       

      I have a sales funnel dashboard setup that shows funnel value based on all kinds of variables like sales stage, product, date.

       

      I want to show a sales order YTD (in millions) value in the same sheet and I can get this using a simple KPI with this formula:

       

      sum([Order Value])/1000000

       

      My problem is that as soon as change a variable like status or product or date, the value goes to ZERO.

       

      Surely I don't have to ignore all of the other field one-by-one?

       

      Is there a way to tell the dashboard to keep the Sum([Order value]) constant, even if I change variables from the other data source?

       

      Kind regards

      Oliver