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/>
