Text Box formula

[danialier]

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

[Nicole-Smith · Accepted solution]

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.

[preminqlik]

try with variables

[its_anandrjs]

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

[MK_QSL]

As Nicole Said, You can create a variable for your Q1 and Q2 expresion and use them in third text box

$(vQ2)/$(vQ1)-1