Skip to Content
0
Former Member
Apr 15, 2010 at 11:27 AM

Enable Excel Iterative Calculation

68 Views

Hello everybody.

I'm going to try to explain my issue; it could be a little bit long:

In my Xcelsius Dashborad, the user can make a selection on a List Box component. The value selected is the prompt for a QAAWS that retrieves more detailed data.

I refresh a graphic based upon one of the columns retrieved. And here comes my trouble: the value could be blank.

In this case, I want my graphic remains unchanged.

For doing this, I'm trying to create a formula that copies the value when it changes but left it unchanged (the prior value) when it becomes blank. My first try results in a circular reference 😔

In B1 cell --> =IF(AND(B1<>A1;A1<>"");A1;B1)

I've found that there is a way to allow Excel to deal with that. (see this link: http://office.microsoft.com/en-us/excel/HP100662431033.aspx).

But if I allow circular references in a separete Excel template and then import it into Xcelsius, it seems that goes crazy, and becomes with an unpredictable behavior, and almost always Xcelius brakes after a while.

So, what I want to achieve is that when a A cell changes, copy its value to another B cell, and when A becomes blank, do nothing (left the previos value in B).

I hope I've made understood the problem and anybody can help.

Thanks in advance.