Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have three text boxes: A, B and C.
> In Text Box A I have a formula that shows the revenues in Quarter 1
> In Text Box B I have a formula that shows the revenues in Quarter 2
> In Text Box C I want to calculate the quarter over quarter growth, so this is Q2/Q1-1
Formulas behind text box A and B are quite complex, so if I need to estimate the quarter over quarter growth with these formulas in text box C it will be quite challenging...
Question: is there a way to put in Text Box C a simple formula saying: Object ID (from Text Box B) / Object ID (from Text Box A) -1
Actually the Object ID from Text Box A is AAA and the Object ID from Text Box B is BBB, so formula would be like BBB/AAA-1
Please help !
dani
Dani Alier wrote:
Question: is there a way to put in Text Box C a simple formula saying: Object ID (from Text Box B) / Object ID (from Text Box A) -1
No. But you can store each calculation in a variable, and call the variables in the text boxes instead.
Dani Alier wrote:
Question: is there a way to put in Text Box C a simple formula saying: Object ID (from Text Box B) / Object ID (from Text Box A) -1
No. But you can store each calculation in a variable, and call the variables in the text boxes instead.
try with variables
Hi,
By variable you are able to do this like
(vQ2revenue / vQ1revenue) -1
and do calculation in variables that are in your Text Box A = vQ1revenue like
Text Box C = vQ2revenue
Hope this helps
Thanks & Regards
As Nicole Said, You can create a variable for your Q1 and Q2 expresion and use them in third text box
$(vQ2)/$(vQ1)-1