Hope someone can help with my simple request.

 

I have 3 boolean fields.

 

KUCHECK

GTCHECK

FACHECK

 

these fields produce either TRUE or null

 

I have wrote a formula ( {@KUDETAIL} )for each field like:

 

IF {TABLE.KUCHECK}= TRUE THEN "KD" ELSE ""

 

 

works great!

 

my problem is,

some customers have TRUE in  2 or 3 of these fields, and when I try to concatenate the formulas, it displays blank.

 

 

my concatenate formula is like:

 

{@KUDETAIL}+{@FADETAIL}+{GTDETAIL}

 

 

returning these results:  ( " - " represents blank)

 

 

Customer name     KUcheck     FAcheck     GTcheck      Concatenate

CUSTOMER A            TRUE              -                -                     -

CUSTOMER B            TRUE          TRUE         TRUE             KDFAGT

CUSTOMER C            TRUE             -             TRUE                  -   

 

 

 

when it should be returning:

 

 

 

 

 

Any ideas?

 

All help greatly appreciated.

 

 

thanks for this.

 

 

regards,