Hello Aaron,
Wednesday, April 20, 2005, 4:19:55 PM, you wrote:
> I have a simple calculation that I need assistance with, it is below:
> DebitAmt =
> If(TransType ="Teleconference Tape-Jan" or TransType = "Teleconference
> Tape-Feb" or TransType = "Teleconference Tape-Mar" or TransType =
> "Teleconference Tape-Apr" or TransType = "Teleconference Tape-May" or
> TransType = "Teleconference Tape-Jun" or TransType = "Teleconference
> Tape-Jul" or TransType = "Teleconference Tape-Aug" or TransType =
> "Teleconference Tape-Sep" or TransType = "Teleconference Tape-Oct" or
> TransType = "Teleconference Tape-Nov" or TransType = "Teleconference
> Tape-Dec" ; 0; ""))
> I am using FM7 hosted by an FM7 server running on WIN2K SP4.
> The calculation seems to work fine, but this is the issue I am running
> into. When the TransType = "payment" or anything not mentioned above I
> want the DebitAmt field to be equal to nothing. In FM5, this
> calculation would leave the actual debitAmt field blank, now it inserts
> a zero. So, essentially the end of the calculation would look like
> this:
> or TransType = "Teleconference Tape-Dec" ; 0; 0)).
> I really need the field to appear blank ("") if one of those transtype's
> is not selected. Please advise.
> Thanks for the help.
> -Aaron
> --
> To unsubscribe: send an email to <[EMAIL PROTECTED]>
> FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
I use FMP7.0v3 and I tried this out with a very simple calculation field and the
field behaved as expected giving 0 or empty. It also worked OK with a
more complex condition, more like the one that you have above. Are you using the
latest version of FMP7?
--
David
--
To unsubscribe: send an email to <[EMAIL PROTECTED]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
