Skip to content
+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
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.