AnsweredAssumed Answered

X IN A BOX

Question asked by carlz_1 on Feb 11, 2009
Latest reply on Feb 12, 2009 by raybaudi

Title

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.

Outcomes