3 Replies Latest reply on Feb 12, 2009 10:42 AM by raybaudi

# X IN A BOX

X IN A BOX

### Post

SORRY, THIS SOUNDS LIKE  A VERY DUMB QUESTION BUT I HAVE BEEN WORKING ON IT FOR HOURS AND DON'T KNOW WHAT I AM DOING WRONG.

I HAVE A FORM THAT HAS A SIMPLE BOX THAT READS NONE (with a square next to it to check).  IT WANTS TO KNOW IF A PERSON HAS CERTAIN ASSETS SUCH AS LIFE INSURANCE.

I WANT TO HAVE A SIMPLY CALCULATION THAT WILL PUT AN X IN THAT BOX IF A PARTICULAR FIELD IS NULL (THEY OWN NO LIFE INSURANCE) AND REMOVE THE X IF THERE IS ANY DATA INPUT REGARING A POLICY.

MY CALCULATION IS:

Case ( RESIDENT::total_lifeins_count = ""; "X";"")

TOTAL_LIFE_INS_COUNT IS A CALCULATION FIELD THAT SIMPLY COUNTS THE NUMBER OF POLICIES SOMEONE HAS BY THE NUMBER OF ENTRIES IN THE LIFE INSURANCE TABLE.

ANYWAY, IT DOESN'T WORK.  THE X GOES IN THERE AND STAYS THERE I EVEN PUT THE TOTAL_LIFE_INS FIELD NEARBY SO THAT I COULD SEE WHAT IT POPULATED WITH.  IT POPULATED JUST FINE BUT THE X WOULD NOT LEAVE.  I TRIED NUMEROUS ITERATIONS USING ISEMPTY() ETC ETC ETC.

I AM DOING SOMETHING WRONG BUT I SUSPECT IT IS A SIMPLE ISSUE.

THANKS AGAIN.

• ###### 1. Re: X IN A BOX

Hi carlz

Not sure from you post why the calc you have setup would not work, could you post into on the  'total_lifeins_count' calc and how the relationships are setup between RESIDENTS and the LIFE INSURANCE TABLE?

One thing tro try though is to set your X field to look directly at the same source your 'total_lifeins_count' instead of the count, so try:

If ( not IsEmpty ( Residence_LIFE INSURANCE TABLE::UniqueID ) ; "X" ; "" )

Resedence_LIFE INSURANCE TABLE is the name of whatever table you have set to link RESIDENCE to the LIFE INSURANCE TABLE

Hope this helps in some way.

• ###### 2. Re: X IN A BOX

As always, thank you for the assistance.

It stil does not work.  Very odd.  I placed a copy of the total_lifeins_count field onto the layout and when I entered a new policy, it came up with a 1.  I tried change from ISEMPTY to a numbe calculation of > 0.  Still, the X persists.  This is one of those situations where I think I may be changing so many things to debug it that I have created a royal mess.

I tried your answer as well. ... Still, the X will not go away.  If you think of anything else, please let me know.

Thank you again.

• ###### 3. Re: X IN A BOX

Hi carlz

> I HAVE A FORM THAT HAS A SIMPLE BOX THAT READS NONE (with a square next to it to check)

So you have a value list of only a value, "none", attached to a calculated field formatted as a checkbox.

> MY CALCULATION IS: Case ( RESIDENT::total_lifeins_count = "" ; "X" ; "" )

Try: Case( IsEmpty ( RESIDENT::total_lifeins_count ) ; "none" )