if(approved_day_13='N' ,255,16777215)
I have the above expression in a column of a datawindow that looks at the value in the approved_day_13 column and then sets the background color to red or white. It works fine when i retrieve the datawindow.
However, if I programmatically in PowerScript change the value in the approved_day_13 column using SetItem(), the background color doesn't change until I save and re-retrieve the datawindow. Shouldn't the expression re-evaluate when a referenced column changes?
Assuming this isn't going to get "fixed" anytime soon, is there a workaround?
Somebody else apparently had a similar problem about 6 years ago.