I have an UltraGrid with 5 bands, using a DataSet as the underlying datasource. In 3 of the 5 bands, I have 15 unbound columns using an UltraCalcManager to do SUMs of child bands. (It does a bottom-up summation).
Every few times we load the grid with data, the "#Calculating" text appears, the UltraCalcManager does its thing, but a few cells might end up with "#VALUE!" in the cell. Next time I reload the DataSet, I might get 0 "#VALUE!"s, or I might get them in different cells.
Am I doing something wrong, or is this a "bug" with the UltraCalcManager?
Thanks,Kyle
P.S. - Attached is a screenshot as a single example.
Hi Kyle,
#VALUE indicates a value error in the calculations. If this is truly coming up at random, then it might be some kind of timing issue, but more likely, this is just the result of some calculation that is resulting in an error for some reason.
What version of the controls are you using?
What kinds of formulas are you using? Which functions are you using?
I apologize for the delayed response. I'm just now getting back to this project.
I'm using version 10.2.20102.1004. It truly is random. When I refresh the grid, with the same data, the #VALUE either totally disappears, or appears in another cell. It feels as though it's a asynchronous call that just times out or dies.
I'm only using SUM and IF functions. My formulas look similar to this: sum([../customers_orders/uctotalcost]) orif(sum([../customers_orders/uctotalsp])=0,0,sum([../customers_orders/uctotalcontrib])/sum([../customers_orders/uctotalsp]))