I have a situation in which I am setting a certain “computed” field, “F1”, with a Value formula. I would like to set field “F2” which is “computed when composed” within the Value formula for “F1”.
In the Value formula of “F1” I have code like
@If( F3 = “Pend” ;
@Setfield( “F2” ; “NewV” ) ;
“” ) ;
@Return( “NewV” )
There is no error, but “F2” is unchanged after a recalc! F1 does change to “NewV”. I have verified that “F3” is indeed “Pend” at the time. I even tried
@If( F3 = “Pend” ;
@Setfield( “F2” ; “NewV” ) ;
@Setfield( “F2” ; “BadBadV” ) ) ;
@Return( “NewV” )
Again, F2 is unchanged after a recalc (View/Refresh F9).
Documentation does not forbid @SetField within a Value formula.
All this works when transplanted into a PostRecalc() formula, but why not in the Value formula?
I am using R8.5.3 and Windows 7 .