Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- Knowledge
- Question Forum
- error formula quiz question

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-11-2020
02:19 PM

I try to generate a question with a formula, in the step to define the formula I keep getting the following error message: "expecting a value at 1, got a equals". In Excel the formula works without fault. What does this error mean? What am I doing wrong?

just to be complete I've added my formula and the variable definitions below:

formula "=(k0*(1+((1+(iy/100/ix))^ix-1))^n)*(1+((1+(iy/100/ix))^ix-1)*q/365)"

variables k0 between 4000 and 50000

iy between 1 and 10

ix between 1 and 12

n between 1 and 10

q between 1 and 364

Solved! Go to Solution.

1 Solution

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Not the Solution
- Email to a Friend
- Report Inappropriate Content

02-11-2020
02:52 PM

Hello merel.bergen@kdg.be...

I'll start out by saying that I'm not an instructor (I'm a Canvas administrator at our school), and I don't teach math courses...nor do I use the formula question type regularly. So, my response may be completely off...in which case, I'm hopeful that someone else might be able to chime in. But, I'm gonna give this a shot. Please check out the following screen shot from my own sandbox course using your formula:

There are a few things I've highlighted:

- First, notice at the top of the screen, all your variables need to be in the square brackets. You may have your question configured this way already.
- At the bottom, I believe your formula should look like what I've displayed above. No equals sign needed to start.
- The right column with the example values is what I think may have been causing the issue that you described...as I also saw that same message. When I initially set up he question, there wasn't a number in that column for every row. But, after I hit the "Recompute" button, numbers filled in, and the error message I saw went away. So, I'm assuming that it will also go away for you, too. (And, I can click on "Recompute" as much as I want to generate different numbers for all rows.)

I hope this will work for you, too, Merel. Let Community members know if you have any questions...thanks!

2 Replies

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Not the Solution
- Email to a Friend
- Report Inappropriate Content

02-11-2020
02:52 PM

Hello merel.bergen@kdg.be...

I'll start out by saying that I'm not an instructor (I'm a Canvas administrator at our school), and I don't teach math courses...nor do I use the formula question type regularly. So, my response may be completely off...in which case, I'm hopeful that someone else might be able to chime in. But, I'm gonna give this a shot. Please check out the following screen shot from my own sandbox course using your formula:

There are a few things I've highlighted:

- First, notice at the top of the screen, all your variables need to be in the square brackets. You may have your question configured this way already.
- At the bottom, I believe your formula should look like what I've displayed above. No equals sign needed to start.
- The right column with the example values is what I think may have been causing the issue that you described...as I also saw that same message. When I initially set up he question, there wasn't a number in that column for every row. But, after I hit the "Recompute" button, numbers filled in, and the error message I saw went away. So, I'm assuming that it will also go away for you, too. (And, I can click on "Recompute" as much as I want to generate different numbers for all rows.)

I hope this will work for you, too, Merel. Let Community members know if you have any questions...thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Accept as Solution
- Email to a Friend
- Report Inappropriate Content

02-11-2020
08:41 PM

I think you hit it with the second item, Chris. There is no = at the beginning.

Related Topic

- Formula Questions - Javascript, Restrictions with Question Type in Question Forum
- Limit to number of questions in banks in Question Forum
- How to use sine inverse ; cos inverse and tan inverse in a formula question in Question Forum
- Canvas Report - Configure Report in Question Forum
- How to Edit a Module With a Document Attached in Question Forum

- Reference
- Community Guidelines
- Security
- Developers
- Open Source