Thanks Tom - it worked!
> @jpardicusick said: > Gotcha, field name instead of question number. It looks like the field name still not complete though. Try using the 'insert piped text' when you're building your formula and input your Embedded Data names from there. It'll put the necessary code in so that Q will read it as an Embedded Data field and compute correctly. > I used the 'insert piped text' and it now works! Thanks SO much!!!!
Hmmm...I thought I did declare the fields. Q118 is the field name I declared for the 1st quarter return, Q218 is the field name for the 2nd quarter return, and so forth (Those fields are not question numbers). I assigned the entered text from each question to these fields. Was that wrong? Below are the steps needed in order to get the computed return: * First, each quarterly return is divided by 100, then increased by 1 (i.e. - 5.23 / 100 + 1 = 1.0523) * Next, multiply each de-annualized return by each other (i.e. - 1.0523 * 1.0325 * 1.0136 * 1.0145 = 1.1833) * Subtract 1 from this number (i.e. - 1.1833 - 1 = 0.1833) * Lastly, multiply by 100 (i.e. 0.1833 * 100 = 18.33)
@jpardisusick - thanks! My embedded data block is after the question block. I tried your 2nd suggestion and presented the table again. However, now I'm getting the word 'invalid' in the last column. !
Thanks TomG! That works for me.
Hmm...all respondents will have answers from previous surveys, but not all of the boxes will have entries. Below is an example of the previous survey (Q3 2018). ! The current survey (Q4 2018) should be pre-filled with the 9/30/2018 market values. !
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.