Skip to content
+1-888-319-3663

COMMUNITY FORUM

Value of field 'CR' is invalid as it is not set until after the rolling column

Adrian Harris asked 6 years ago
I entered the script below as a calculated field and I receive the error above.  Is ther e something wrong with syntax?
 
if(_JOURNALDEBITORCREDIT == “DR”){
return _JOURNALAMOUNT ;
}
else{
 return “0”;
}
 
 
Patrick Roth Staff replied 6 years ago

Adrian,

I don’t think that the error is coming from this calculation.

When you press the Validate button, SC compiles all the scripts on the map and reports all errors.

From the error, I believe you have a rolling column and then a calculation after that. The rolling column references that calculation and the error is telling you need to switch the order.

In your calculations, try moving the rolling column down to the last position and re-validate.
patrick

Answers
Adrian answered 6 years ago
Hello Patrick I deleted and recreated the map, which solved my issue.

If you would like to submit an answer or comment, please sign in to the eOne portal.