Create variable and use variable
Posted: Wed Feb 24, 2016 11:37 pm
Hi
I want to calculate a value and store in a variable and re-use the variable for further calculations in my report page. I am not sure exactly how would I do that so if you know different methods please advise.
I want to create a new variable which is a % increase/decrease of last 2 years and based on this number I want to calculate rest of numbers.
For example:
~Revenue year 1 = 1200
~Revenue year 2= 1320
~ProjRev (Variable)= (Revenue year 2- Revenue year 1)/ Revenue year 1
Using variable within different objects - Textbox, Charts
~Income Taxes * ProjRev
~Interest * ProjRev
please advise, how to create a variable and use/re-use this variable in calculation in same report.
please reply at earliest convenience.
Thanks
Pat
I want to calculate a value and store in a variable and re-use the variable for further calculations in my report page. I am not sure exactly how would I do that so if you know different methods please advise.
I want to create a new variable which is a % increase/decrease of last 2 years and based on this number I want to calculate rest of numbers.
For example:
~Revenue year 1 = 1200
~Revenue year 2= 1320
~ProjRev (Variable)= (Revenue year 2- Revenue year 1)/ Revenue year 1
Using variable within different objects - Textbox, Charts
~Income Taxes * ProjRev
~Interest * ProjRev
please advise, how to create a variable and use/re-use this variable in calculation in same report.
please reply at earliest convenience.
Thanks
Pat