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.