4 Replies Latest reply: Sep 22, 2017 1:11 PM by Russell Glenn RSS

    Set Analysis with Revenue Variable

    Russell Glenn

      Hello,

       

      We have changed our revenue to a variable calculation. I am trying to enter in an equation that will use our revenue variable and work within the following set analysis. When I update to the variable, I get 0's, so I am not sure if it is working correctly. Any thoughts would be great thanks!

       

      Before:

       

      =sum({$<[Year Breaks]={"0-2 years"}>}[Revenue (dollars)])

       

      Attempt:

       

      =sum({$<[Year Breaks]={"0-2 years"}>}$(vRevenue$))