Calculation with numbers and text

[wildzim]

Hi,

I'm having a little problem with doing a calculation what has both a dollar value and text. When I set the calcuation as a text, then the numbers are not formated in the correct demcimal places and the "$" sign is missing. When I set the calcuation as a number, then the text disappears.

Here is my code:

[color:blue]Case(

Contract Term = "Two", "The Contract total for the two year term is: ¶Year One: " & Grand Total & " ¶Year Two:" & Two Year Contract Total & "¶Total Contract Cost " & Contract Term Total,

}

This is the Result:

[color:blue]The Contract total for the two year term is:

Year One: 682

Year Two:750.2

Total Contract Cost 1432.2

Is there a way for me it fix this problem.

thanks....

[Søren Dyhr]

Although there are obvious limitations to the version you're on should you poke into this thread:

http://www.fmforums.com/forum/showtopic.php?tid/192210/post/276584/#276584

In your case does it seem like you should write the text in layoutmode and then include mergefield of the field values each formatted to the requirements.

--sd

[_henry_]

Hi Wildzim,

You can also read this topic:

http://www.fmforums.com/forum/showtopic.php?tid/192147/

Hope it helps...

[wildzim]

Thank you for prompt replies. Looks like I'm going to have to use merge fields.

Thanks for the help.

[Lee Smith]

I think from what you have posted, that you are going to need some flexibility in the amounts that you quote. Unless I'm mistaken by what you posted as a sample, I'm guessing that you have at least two different periods that will require quotes, I.e. a one year contract, and a two year contract. Is there going to be longer contracts?

To get you started, I made a quick sample of two ways to accomplish the two year contract. This would change if there is a One, Two, Three, Four, etc. contacts too.

HTH

Lee

wildzim2.fp5.zip

Edited December 31, 2007 by Guest

[LaRetta]

As Lee suggests, I see many 'same' fields indicating possibility of more.

If these 'contracts' were records, formatting their dollar amount would be piece of cake. I suggest considering a relational structure over multiple calcultions within one file.

[wildzim]

Thanks for that Lee. That's exactly what I needed. There are more options for the contracts... 1 year, 2, 3, 4 and 5 year contacts.