Aaron,
FMD 7.0v3 on XP Pro SP2 - I get a "blank" when TransType doesn't equal one of
the values in the list. Unfortunately, I can't try it on your setup to see if
it makes a difference. However, i would suggest either (1) using a Case()
statement instead of an If() statement; or (2) use GetAsNumber("") instead of
"" in your original calculation.
All the Best,
Jason L. DeLooze
Annapolis, MD USA
410-626-7415
AIM: Jason L DeLooze
On 4/20/05 at 11:19 -0400, Aaron Woitkovich 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/>
--
To unsubscribe: send an email to <[EMAIL PROTECTED]>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
