Hi,
FIELD A :=A;
FIELD B :=B;
t1:=@If((Status=“Billing in Process”&Payterm=“Quarterly in Advance”); @Adjust(B;0;3;0;0;0;0);@Return(“”));
t2:=@If(Status=“Billing in Process”&Payterm=“End of Quarter”;@Adjust(A;0;3;0;0;0;0);@Return(“”));
@If(@IsError(t1);"Error ";t1);
@If(@IsError(t2);"Error ";t2)
there is a field called Duedate ( DateTime,Computed) in which this code is written
also field A,B are(DateTime,Computed)
problem is ,value appear in some document but not in all document with same if qualifying conditions??
thx in advance
Subject: RE: @Ajust not showing value in all document
The purpose of the computed field formula is to calculate a value for your field DueDate.
@Return(“”) says to end the formula execution, using “” as the value for DueDate. I’m not sure what you want the formula to do, but I suspect this is not it.
The final two statements:
@If(@IsError(t1);"Error ";t1);
@If(@IsError(t2);"Error ";t2)
Because the statement @If(@IsError(t1);"Error ";t1) is not the last statement, and because it doesn’t use @Return and it doesn’t assign a value to a field or temporary variable, this statement is useless; whatever value it calculates is lost.
What value do you want to appear in this field? From your formula, I am not sure.