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

# Set Analysis with Revenue Variable

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\$))

• ###### Re: Set Analysis with Revenue Variable

How do you set the variable ?

• ###### Re: Set Analysis with Revenue Variable

I set the variable to look at budgeted and actual based on years.

Variable:

if(sum(if(Year>2016 and [Financial View]='Budgeted',[Revenue (dollars)],if(Year<2017 and [Financial View]='Actual',[Revenue (dollars)],0)))=0, '-',

sum(if(Year>2016 and [Financial View]='Budgeted',[Revenue (dollars)],if(Year<2017 and [Financial View]='Actual',[Revenue (dollars)],0))))

• ###### Re: Set Analysis with Revenue Variable

Hi Russell,

This will work for you:

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

While caculating the variable, use = sign before the calculation in variable overview window. Like vRevenue = sum(Revenue).

• ###### Re: Set Analysis with Revenue Variable

Hi Prabhakar,

In terms of variable window, do you mean to edit the variable specifically and add an equals sign at the beginning of

Variable:

if(sum(if(Year>2016 and [Financial View]='Budgeted',[Revenue (dollars)],if(Year<2017 and [Financial View]='Actual',[Revenue (dollars)],0)))=0, '-',

sum(if(Year>2016 and [Financial View]='Budgeted',[Revenue (dollars)],if(Year<2017 and [Financial View]='Actual',[Revenue (dollars)],0))))

Thanks,