I use a text choice variable to select the value that is being graphed. A simple example: I have a formula named "Measure" and a text choice variable named "Which?" with the choices "Number of Items" and "Cost". Depending on the value of "Which?", "Measure" will contain the record count (i.e., the value of a counter variable set to "1") or the value in the "Cost" column (see the code in the error msg, below, for a real-life example). In this way, I can make each of the views on a page graph the same value (i.e. "Measure") with just one mouse click, rather than selecting the item on each view's menu.

I frequently - not every time - get errors when I refresh the file from the database. In the past I've seen out-of-range errors. I've just received this one:

"An unexpected error occurred calculating formula values"
* ClassCastException {class java.lang.ClassCastException No stack trace available}
* "Field: Measure"
* "Record: 4"
* "Expression: IF ([Which] = "Engagements", [Engagements],
IF ([Which] = "Charges", [Project Charge],
IF ([Which]= "FTE", [Project FTE])))"

In every case when I examine the formula in the formula editor, I see "No errors". When I inspect the record that is listed in the error report, I can see nothing out of the ordinary. In the case above the 3 values in Record 4 were, respectively 1, 631.66, 0.02. Of course, "Measure" did not get populated for most of the data set.

When I did a further data refresh I saw no error message and "Measure" was fully populated. However, the Formulas menu on the table view was red and when I selected "View last formula error" it opened the formula editor for "Measure" - which , again, reported "No errors"

I'm using v2.6 b567. I have experienced exactly the same problem with b650.