Value of field 'CR' is invalid as it is not set until after the rolling column
Adrian Harris asked 7 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”;
}
if(_JOURNALDEBITORCREDIT == “DR”){
return _JOURNALAMOUNT ;
}
else{
return “0”;
}
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