- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-19-2016 02:38 PM
Hi Everyone, I'm pretty sure this is a simple and idiotic question, but I can't seem to get anything to work. I'm trying to write a calculated field that checks to see if an integer field is null. I've tried = "", isnil(), nil(), but none of those work. Here is my calculated field:
if (current.u_deductions_adjustments_10.isnil()) { |
current.u_two_earners_1 = current.u_personal_allowance_h;}
else {current.u_two_earners_1 = current.u_deductions_adjustments_10;}
Thanks!
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-19-2016 02:42 PM
In javascript you can just say:
if (!current.u_deductions_adjustments_10)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-19-2016 02:40 PM
Did you try "== null"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-19-2016 02:42 PM
In javascript you can just say:
if (!current.u_deductions_adjustments_10)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-20-2016 06:35 AM
Thanks Kit, that did it!