+1-888-319-3663

COMMUNITY FORUM

Calculated field

gwins12345 asked 9 years ago

I'm trying to create a calculated field that will test if a value is greater than zero. If so, then my credit amount value should be zero or if not then the value of the credit amount should be brought in. When I validate the formula below, I get an error box with no error. Any suggestions?

Thanks.

if _chkamt > 0

then return _cr = 0

else

return _cr

endif

Answers

0 Vote Up Vote Down

Best Answer

Ruaan Jonker answered 9 years ago

Hi

If the map is VB:

if (_chkamnt > 0) then
return 0
else
return _cr
end if

1. The end if needs to be 2 words
2. The "then" after the if statement needs to be on the same line as the "if"

Hope this helps.

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