display text with a calculation

[wally buch]

I would like to have a calculation result also show a text string after the calculated number, e.g. in a merge field. If I have CASE(M>0;Field;)I would like to be able to add a text string after the calculation result for use in a form letter. In other words, if the calculation result is zero then nothing would be in the form letter. If calculation is >0, then the form letter would read 1 "item."

Thanks for any help on this.

[Lee Smith]

I'm not sure that I understand what you want to happen. For one thing, I'm looking at a field called "M", and a field for the calculation.

I'm not sure what the "Field" is for, unless that was for the calculation? See if this does what you want.

Case ( not IsEmpty ( M ) ; "1 Item" )

If not, then maybe you can explain what you have now, and what the result should be, or attach a copy of your file.

Lee

[wally buch]

I tried to make it clear, but failed. I have a database that is tracking meal entree choices for a convention. For example, at lunch there could be three choices, and the registration form has a field for each one, e.g. chicken, beef, vegetarian, and the field data consists of a number of each one chosen. So one couple may have two chickens and another couple one beef, and one vegetarian. This is repeated for each meal on each day.

I am sending all the attendees a form letter merged from the database, reminding them of their choices. Currently, the form letter has chicken (1), beef (1) and vegetarian (0) for thursday lunch. I would like to avoid showing null entries like vegetarian in the form letter if the individuals did not choose it. I need to be able to follow the field "chicken" value with the word "chicken" in the form letter.

Thanks for your help in this seemingly mundane effort.

[Lee Smith]

attach a copy of your file, so I can address the separate calculations.

[wally buch]

Lee:

The entire fp7 file is too large to send to you. Any ideas?

[Lee Smith]

You have to zip your file anyway, how big is it Zipped.

Lee

[wally buch]

Unzipped it is 6MB. But....I think I may have solved it with your help. I can use the not isempty for each meal choice and then merge it in. Kind of brute force, but whatever works! I think it will solve the problem. If it doesn't I will compress the file and send it to you.

Again, many many thanks for your kind help.

wally

[Lee Smith]

It really isn't brute strength, it is an acceptable way to approach your need.

There is a 1.5 Mgs per file limit, but you can upload more than one file it it would help.

You an also save a clone "No Records" of your file, and see if that zips down to the limit

Lastly, you can make a mark up of your file, and send that instead. The benefit of this is that we will be talking your actual Fields, Layouts, etc.

Lee

[wally buch]

Lee:

You essentially solved the problem for me and it now works as advertised, so no need to send the file. And, I appreciate the information about file transfers, should the need arise in the future.

Again, many thanks for your advice