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

    Set Analysis with Revenue Variable

    Russell Glenn



      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!




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




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